jia ding wrote:
Hi all,
I tried:
select id, name into table2 from table1;
\copy table2 to filename.txt
in order to export 2 columns from table1 to a file.
But, I am thinking, if there is a command can combine these two command
together?
Maybe, something like: \copy select id,name from table to filename.txt
Close.
copy tablename field1, field2 to 'filename';
http://www.postgresql.org/docs/8.1/static/sql-copy.html
--
Postgresql & php tutorials
http://www.designmagick.com/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
