/SQL/Postgres select as csv

Postgres select as csv

Postgres select as csv

-- To stdout
COPY (select * from table) TO STDOUT WITH CSV HEADER;

-- To file
COPY (select * from table) TO '/table.csv' WITH CSV HEADER;

1

Similar codes

4 votes183 views3 answers
How to describe a table in sqlite3
SQL
1 vote165 views4 answers
Between vs in sql
SQL
0 vote187 views1 answer
Drop-toys-table
SQL
0 vote180 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote192 views2 answers
Compound operator in sql
SQL
0 vote181 views1 answer
Limit and offset in stored procedure mssql
SQL
1 vote214 views1 answer
Nvl postgres
SQL
0 vote197 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote184 views1 answer
Yesql
SQL
0 vote208 views1 answer
Alter domain sql
SQL

Share