COPY .... WITH (FORMAT binary) causes syntax error at or near "binary" - Mailing list pgsql-hackers

From Pavel Golub
Subject COPY .... WITH (FORMAT binary) causes syntax error at or near "binary"
Date
Msg-id 6510382810.20110705175206@gf.microolap.com
Whole thread Raw
Responses Re: COPY .... WITH (FORMAT binary) causes syntax error at or near "binary"
List pgsql-hackers
Hello.

System: PostgreSQL v9.0 Windows XP SP3
SQL: COPY "tablename" TO STDOUT WITH (FORMAT binary)
ERROR:  syntax error at or near "binary"
LINE 1: ...OPY "tablename" TO STDOUT WITH (FORMAT binary)                                                 ^

********** Error **********

ERROR: syntax error at or near "binary"
SQL state: 42601
Character: 55

But if I use 'FORMAT text' or 'FORMAT csv' all is OK.

Suppose this happens because BINARY is not listed in
"unreserved_keyword" neither in "col_name_keyword parser" parser rules, but
listed in "type_func_name_keyword" instead.



-- 
With best wishes,Pavel                          mailto:pavel@gf.microolap.com



pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Small SSI issues
Next
From: Robert Haas
Date:
Subject: Re: [v9.2] SECURITY LABEL on shared database object