You can use this
alternative:
\copy (SELECT col1, col2, col3... from cities) TO '/var/lib/pgsql/cities.csv' (DELIMITER ',', FORMAT 'csv', HEADER)
The list col1, col2, col3...
should only contain names on necessary columns and not
under
any circumstances the geometry column
-- Med venlig hilsen / Kind regards Bo Victor Thomsen
Den 04-03-2020 kl. 19:38 skrev
postggen2020 s:
\copy cities TO '/var/lib/pgsql/cities.csv' (DELIMITER ',', FORMAT 'csv', HEADER)
