Hi,
1) I am getting this permission denied error when trying to load JSON data with the parser option. I have checked the user_functions table and the grants table and everything seems to be set up ok with the right permissions.
Any ideas?
2) Do I always have to use the JSON parser using the COPY command in order to process the JSON further or can I load the JSON data to a staging table and then use the JSON parser to process it further?
All the examples I have seen use the JSON parser at the initial load i.e.
copy target from source parser FJSONParser();
Thanks,
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.