如何在postgresql函数中输出json文件？

CREATE FUNCTION export_json_file() RETURNS void AS $$

DECLARE
   json_data json;
BEGIN
   SELECT json_agg(row_to_json(t)) INTO json_data FROM your_table t;

   PERFORM pg_write_binary_file('/path/to/output.json', json_data::text);

   RAISE NOTICE 'JSON file exported successfully!';

CREATE FUNCTION export_json_file() RETURNS void AS $$
DECLARE
   json_data json;
BEGIN
   SELECT json_agg(row_to_json(t)) INTO json_data FROM your_table t;
   PERFORM pg_write_binary_file('/path/to/output.json', json_data::text);
   RAISE NOTICE 'JSON file exported successfully!';
END;
$$ LANGUAGE plpgsql;