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/
