From: | "Stephen Boyle" <yd80(at)dial(dot)pipex(dot)com> |
---|---|
To: | "bluexiao" <bluexiao(at)yeah(dot)net>, "postgreSQL" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] about copy |
Date: | 1999-07-20 17:29:06 |
Message-ID: | 002b01bed2d5$63af9170$010aa8c0@m0n7y |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
COPY Copies data between files and tables
COPY [ BINARY ] table [ WITH OIDS ]
FROM { 'filename' | stdin }
[ USING DELIMITERS 'delimiter' ]
COPY [ BINARY ] table [ WITH OIDS ]
TO { 'filename' | stdout }
[ USING DELIMITERS 'delimiter' ]
-----Original Message-----
From: bluexiao <bluexiao(at)yeah(dot)net>
To: postgreSQL <pgsql-general(at)postgreSQL(dot)org>
Date: 18 July 1999 23:09
Subject: [GENERAL] about copy
>Hello:
> I want to import some data from access97 to postgres, I have save
>the data to .CSV file, but how to import it into postgres's db?
> I no there is a command in psql can do it. But I forget.
>
>=-=-=-=-=-=-=-=
> Take care
>=-=-=-=-=-=-=-=
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gerry D'Costa | 1999-07-20 17:38:27 | |
Previous Message | Tom Lane | 1999-07-20 14:53:39 | Re: [SQL] bad select performance for where (x=1 or x=3) |