Re: COPY problem - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY problem
Date
Msg-id 4865.1024782923@sss.pgh.pa.us
Whole thread Raw
In response to COPY problem  (Varun Kacholia <varunk@cse.iitb.ac.in>)
List pgsql-general
Varun Kacholia <varunk@cse.iitb.ac.in> writes:
> The command works when used from the psql prompt but gives the following
> error when called using perl.

>  ERROR:  parser: parse error at or near ".9"

This sure looks like the contents of the data file are being fed to the
main SQL parser (and not the COPY code at all).  Perhaps Perl is doing
some sort of weird interpolation on your command string?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optimizing suggestions
Next
From: Tom Lane
Date:
Subject: Re: SQL server application porting headache