Re: quicky postgreSQL question

1998-11-25 Thread maximill
On Wed, 25 Nov 1998, Shaleh wrote: > > That is exactly what I wanted thank you. > > db=> copy stdcal from /vservers/stdcal/users/root/gem_inv.txt using delimeters > ,; > > the database is db, the table is stdcal, the file contains the wanted data. > > When I run this I get a "parse error at o

Re: quicky postgreSQL question

1998-11-25 Thread Oliver Elphick
Shaleh wrote: >How can I read in a comma delimited file and have the contents added to a SQ >L >table? I seem to recall there being a program that did this for postgres. The command you want is copy (from inside psql). COPY [BINARY] class_name [WITH OIDS] TO|FROM filen

Re: quicky postgreSQL question

1998-11-25 Thread Shaleh
On 25-Nov-98 Eric Jacoboni wrote: > Shaleh <[EMAIL PROTECTED]> writes: > >> How can I read in a comma delimited file and have the contents added to a >> SQL >> table? I seem to recall there being a program that did this for postgres. > > I'm not sure to have understood what you mean, but in psq

Re: quicky postgreSQL question

1998-11-25 Thread Greg Vence
Shaleh wrote: > > How can I read in a comma delimited file and have the contents added to a SQL > table? I seem to recall there being a program that did this for postgres. > In the comercial world, several vendors call it bcp. Don't have access to psql here... yet. -- What do you want to spen

Re: quicky postgreSQL question

1998-11-25 Thread Eric Jacoboni
Shaleh <[EMAIL PROTECTED]> writes: > How can I read in a comma delimited file and have the contents added to a SQL > table? I seem to recall there being a program that did this for postgres. I'm not sure to have understood what you mean, but in psql, you can issue a "\copy table from file"... fi

Re: quicky postgreSQL question

1998-11-25 Thread Jeff Noxon
On Wed, Nov 25, 1998 at 02:47:53PM -0500, Shaleh wrote: > How can I read in a comma delimited file and have the contents added to a SQL > table? I seem to recall there being a program that did this for postgres. I've always done that kind of thing using Perl. You can use the postgres libraries,

quicky postgreSQL question

1998-11-25 Thread Shaleh
How can I read in a comma delimited file and have the contents added to a SQL table? I seem to recall there being a program that did this for postgres.