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

2000-08-24 Thread Mike Mascari
> On Thu, 24 Aug 2000, Roderick A. Anderson wrote: > > > On Thu, 24 Aug 2000, John McKown wrote: > > > > > I think that you can do this using the COPY verb in psql. > > > > > > COPY table FROM file USING DELIMITERS ','; > > > > Be aware you will probably have to start psql as the postgres (sup

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

2000-08-24 Thread John McKown
On Thu, 24 Aug 2000, Roderick A. Anderson wrote: > On Thu, 24 Aug 2000, John McKown wrote: > > > I think that you can do this using the COPY verb in psql. > > > > COPY table FROM file USING DELIMITERS ','; > > Be aware you will probably have to start psql as the postgres (superuser) > to use t

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

2000-08-24 Thread Roderick A. Anderson
On Thu, 24 Aug 2000, John McKown wrote: > I think that you can do this using the COPY verb in psql. > > COPY table FROM file USING DELIMITERS ','; Be aware you will probably have to start psql as the postgres (superuser) to use the COPY command. But ... the \copy version is usable by normal us

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

2000-08-24 Thread 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: > > D

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

2000-08-24 Thread John McKown
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