Re: Importing into Postgres from a csv file - Mailing list pgsql-general

John McKown wrote:
>
> I think that you can do this using the COPY verb in psql.
>
> COPY table FROM file USING DELIMITERS ',';
>
> Just be sure that the order of the data in the file is the same as the
> order of the variables in the table.
>
> John
>
> On Wed, 23 Aug 2000, Jake wrote:
> > Does any one know if this is possible, and if so how?
> >
> >
> > Jake
> >
> >

COPY table FROM '/usr/file' USING DELIMITERS ',';

with the complete path.
Jerome.