Dear all,
I have a query in Postgres like below:
EXECUTE FORMAT(
$$ SELECT * FROM %I.%I CROSS JOIN LATERAL json_to_record(%I::json)
AS rs(%s); $$,
'public',
'vehicles',
'column_a',
array_to_string(
(SELECT ARRAY(SELECT DISTINCT col FROM vehicles CROSS
JOIN LATERAL json_object_keys(column_a::json) AS t(col) ORDER BY
col)), ' 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
--
Best Regards,
Joe