Thanks Martijn.
\d test
Table public.test
Column | Type | Modifiers
id | integer |
score| integer |
I tried \copy test (score) to test.txt. It works well.
But, suppose I want to select rows with score 20 (just an example).
Then,\copy table [ ( column_list ) ] { from |
yes, of couse COPYbut,= copy test to 'test.txt';ERROR: must be superuser to COPY to or from a fileHINT: Anyone can COPY to stdout or from stdin. psql's \copy command also works for anyone.
On 3/16/06, Chris [EMAIL PROTECTED] wrote:
jia ding wrote: Hi all, I tried: select id, nameinto table2 from
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 ?Nina