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

[GENERAL] importing into postgres from access

2000-07-11 Thread nsrona
I currently have postgres on a Linux 6.2 machine & I can access all of its information from any windows machine using the proper odbc driver. Now I want to go in the other direction - Is there a way for my postgres server on the linux box to pull down information from a windows client that is usi

[GENERAL] importing into postgres

1998-07-23 Thread Kevin Heflin
I'm using the IMPORT Table feature of pgaccess to import a .txt file. I've done this before and usually have no problems.. The table I'm importing into however has a field which I intended to be an auto numbering field.. INT DEFAULT nextval('team_id') and I have a sequence of team_id however wh