super query

superQuery.sql

SET TIME ZONE 'America/Sao_Paulo';
\copy (
select a,b,c,d from x
) TO '/tmp/arquivo.csv' DELIMITER ',' NULL 'NULL' CSV HEADER FORCE QUOTE a,b,c,d
SET TIME ZONE 'UTC';


--



\copy (
SELECT
    unnest(lala) AS lala
  FROM lala LALA
  WHERE lala = lala
    AND lala.arrayXXX @> array[xxxItem]::bigint[]
) TO '/tmp/xxxx.csv' CSV DELIMITER ',' HEADER FORCE QUOTE lalaId;