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 or near "/"". \h copy says this is > the > right syntax. Suggecstions?
try putting quotes around the path/filename. Also, another suggestion to consider, if you have to do a lot of this type of thing: perl has a very nice database interface called DBI. DBI has modules for connecting to many type of databases, including csv (comma separated values) and pg (postgresql). just install libdbd-csv-perl and libdbd-pg-perl, then writing a perl script to make these two talk to each other is trivial. -brad
