COPY .... WITH (FORMAT binary) causes syntax error at or near "binary"

Поиск
Список
Период
Сортировка
От Pavel Golub
Тема COPY .... WITH (FORMAT binary) causes syntax error at or near "binary"
Дата
Msg-id 6510382810.20110705175206@gf.microolap.com
обсуждение исходный текст
Ответы Re: COPY .... WITH (FORMAT binary) causes syntax error at or near "binary"  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Small SSI issues
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [v9.2] SECURITY LABEL on shared database object