PostgreSQL Export table into CSV file
To export a table into CSV file, run
\copy TABLE_NAME to 'FILE_NAME.csv' csv header;
This will save the CSV file in current directory.
To export a table into CSV file, run
\copy TABLE_NAME to 'FILE_NAME.csv' csv header;
This will save the CSV file in current directory.