Re: [GENERAL] Importing into Postgres from a csv file

[Jerome Raupach]

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.