Answers for "Save PL/pgSQL output from PostgreSQL to a CSV file"

Whatever

0

Save PL/pgSQL output from PostgreSQL to a CSV file

>psql dbname
psql>f ','
psql>a
psql>o '/tmp/output.csv'
psql>SELECT * from users;
psql>q

----------------------------------
COPY (SELECT * from users) To '/tmp/output.csv' With CSV;

-----------------------------------------
psql -d dbname -t -A -F"," -c "select * from users" > output.csv

Posted by: Guest on January-26-2022

Source

Code answers related to "Save PL/pgSQL output from PostgreSQL to a CSV file"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#