On Mon, 1 Apr 2002, Marcus Claesson wrote: > > Why are you trying to put a backslash in there. DBI is not the psql tool! > > Get rid of the backslash. > > The reason for using \COPY here is that you otherwise have to be superuser to > copy (with the plain COPY) the data into a created table. I'm building a web > interface where the user will copy his data into the db himself and thus > obviously cannot be the superuser. > Of course, that can be done with INSERT too but a COPY is much faster.
There is no "\copy" in the SQL docs, is there? The fact that there happens to be a command you can use in psql called "\copy" does not mean that there is an equivalent SQL statement. -dave /*================== www.urth.org we await the New Sun ==================*/
