MSNCodeSNIPPETS← msncode.dev
snippets/postgres

Export Table to CSV

Export a PostgreSQL table to a CSV file

postgressqlexportcsv
SQL
\COPY table_name TO '/path/file.csv' WITH CSV HEADER

More postgres snippets

Create User and Database

Create a new PostgreSQL user and database

Describe Table Structure

Show columns, types, and constraints of a table

Find Duplicate Rows

Find rows with duplicate values in a column

Kill a Running Query

Cancel a long-running PostgreSQL query by PID