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 doesn’t 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:
Just select the additional value:
select id, name, email, current_date as "date" from the_table;
select id, name, email, date '2018-10-09' as "date" from the_table;
You can COPY or copy from an arbitrary query if you put parentheses around it.
copy (select id, name, email, now() as "date" from example) to file.csv with (format csv)