The following bug has been logged online: Bug reference: 5411 Logged by: Vitalii Tymchyshyn Email address: tiv...@gmail.com PostgreSQL version: 8.4.3 Operating system: OpenSuse 11.2: Linux tivv 2.6.31.12-0.1-default #1 SMP 2010-01-27 08:20:11 +0100 x86_64 x86_64 x86_64 GNU/Linux Description: \copy do not work with dot "." in query Details:
dict=> \copy (select 1.0) to test.tst ERROR: syntax error at or near "." LINE 1: COPY ( select 1 . 0 ) TO STDOUT ^ \copy: ERROR: syntax error at or near "." LINE 1: COPY ( select 1 . 0 ) TO STDOUT ^ Workaround: \copy (select 1::float8) to test.tst works OK. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs