Re: quicky postgreSQL question

[maximill@shelob.classrooms.washington.edu]

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