Skip site navigation (1) Skip section navigation (2)

BUG #5411: \copy do not work with dot "." in query

From: "Vitalii Tymchyshyn" <tivv00(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5411: \copy do not work with dot "." in query
Date: 2010-04-09 09:20:30
Message-ID: 201004090920.o399KUEU074080@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5411
Logged by:          Vitalii Tymchyshyn
Email address:      tivv00(at)gmail(dot)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.

Responses

pgsql-bugs by date

Next:From: Robert HaasDate: 2010-04-09 12:08:03
Subject: Re: bugs that have not been replied-to on list
Previous:From: Wolfgang.KoenigDate: 2010-04-09 08:49:32
Subject: initdb stores default client_encoding from environment-variable

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group