can i export|copy multiple postgresql queries into one csv file?

Question

Is it possible to copy multiple postgresql queries into single csv file? As of now am copying single query into csv file as

copy (select * from table1) to 'file.csv' with csv header;

Now i want to copy 2 query result together . Is that possible ? something like,

copy (select * from table1,select name from table2) to 'file.csv' with csv header

Any help?

Ihor Romanchenko · Accepted Answer · 2012-12-05 22:02:22Z

3

You can:

copy (select 'table1' as table_id, * from table1
      UNION ALL
      select 'table2' as table_id, * from table2)
 to 'file.csv' with csv header

If tables have identical structure.

Or you can:

copy (select field1, field2, null, null from table1
      UNION ALL
      select null,null, field3, field4 from table2)
 to 'file.csv' with csv header

If tables don't have identical structure.

The problem is - COPY ... FROM can only work with tables (details here).

So you will need to: CREATE TEMP TABLE tmp_copy_tbl, COPY tmp_copy_tbl FROM and then INSERT ... SELECT ... FROM tmp_copy_tbl

edited Dec 5, 2012 at 22:02

answered Dec 5, 2012 at 10:11

Ihor Romanchenko

29k9 gold badges56 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

can i export|copy multiple postgresql queries into one csv file?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related