EXECUTEFORMAT( $$ SELECT * FROM %I.%I CROSSJOINLATERAL json_to_record(%I::json) AS rs(%s); $$, 'public', 'vehicles', 'column_a', array_to_string( (SELECTARRAY(SELECTDISTINCTcolFROM vehicles CROSSJOINLATERAL json_object_keys(column_a::json) AS t(col) ORDERBYcol)), ' text , ' ) || ' text'
);
I got an error message when I run it in pgadmin: ERROR: prepared statement "format" does not exist SQL state: 26000
Any advice on how to fix it? Thanks
What you want to do?
If you want to run dynamic statement, then you should be in a PLpgSQL environment. If you want to run a prepared statement, then you should use PREPARE statement first.
Attention: Inside Postgres you can use two different EXECUTE statements - inside SQL - EXECUTE runs prepared statement, and inside PLpgSQL - EXECUTE runs dynamic query.