Re: "psql -At -F" export column from table to .csv

[Stephen Frost <sfrost@xxxxxxxxxxx>]

* Nina (dingjia@xxxxxxxxx) wrote:
> I think you maybe familiar with this command:
> psql -At -F "," -c "select ..." > query.csv
> 
> My question is:
> is it possible to export several different columns from different
> tables into the same .csv file; something like:  psql -At -F "," -c
> "select ..." "select ..." "select ..." "select ..." > query.csv
> 
> Then, how to write the command in the correct way?

for table in a b c; do
  psql -At -F "," -c "select ... from $table" >> query.csv
done

	Enjoy,

		Stephen

Attachment: signature.asc
Description: Digital signature