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

[Stephen Frost]

* Nina ([EMAIL PROTECTED]) 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

signature.asc
Description: Digital signature