| 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: | Whole Thread | Raw Message | 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) |