Varun Kacholia <varunk(at)cse(dot)iitb(dot)ac(dot)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