PostGres, copy to a csv file

by user162519   Last Updated October 09, 2018 13:06 PM

On PostGres, I want to load a select query into a csv file. But in the CSV file I want to put some values, that doesnt appear in the query, how do I do that? It's like:

select id, name, email
And then have a Date, which I want to set default in every line. So the csv will be like:

id,name,email,date

Tags : postgresql


Related Questions


Postgres gist slow index f_unaccent

Updated April 09, 2018 20:06 PM