public inbox for [email protected]
help / color / mirror / Atom feedUnderscorces in copy-documentation (9.0 and higher)
6+ messages / 3 participants
[nested] [flat]
* Underscorces in copy-documentation (9.0 and higher)
@ 2013-03-20 10:48 Mario Duhanic <[email protected]>
2013-03-20 14:05 ` Re: Underscorces in copy-documentation (9.0 and higher) Tom Lane <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Mario Duhanic @ 2013-03-20 10:48 UTC (permalink / raw)
To: pgsql-docs
Hi,
- http://www.postgresql.org/docs/9.2/static/sql-copy.html,
- http://www.postgresql.org/docs/9.1/static/sql-copy.html and
- http://www.postgresql.org/docs/9.0/static/sql-copy.html
have underscores ("_") where there should be none,
e.g. in "FORCE_QUOTES".
Best regards,
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Underscorces in copy-documentation (9.0 and higher)
2013-03-20 10:48 Underscorces in copy-documentation (9.0 and higher) Mario Duhanic <[email protected]>
@ 2013-03-20 14:05 ` Tom Lane <[email protected]>
2013-03-20 14:49 ` Re: Underscorces in copy-documentation (9.0 and higher) Ian Lawrence Barwick <[email protected]>
2013-03-20 14:50 ` Fwd: Underscorces in copy-documentation (9.0 and higher) Mario Duhanic <[email protected]>
2013-03-20 14:53 ` Re: Underscorces in copy-documentation (9.0 and higher) Tom Lane <[email protected]>
0 siblings, 3 replies; 6+ messages in thread
From: Tom Lane @ 2013-03-20 14:05 UTC (permalink / raw)
To: Mario Duhanic <[email protected]>; +Cc: pgsql-docs
Mario Duhanic <[email protected]> writes:
> Hi,
> - http://www.postgresql.org/docs/9.2/static/sql-copy.html,
> - http://www.postgresql.org/docs/9.1/static/sql-copy.html and
> - http://www.postgresql.org/docs/9.0/static/sql-copy.html
> have underscores ("_") where there should be none,
> e.g. in "FORCE_QUOTES".
Huh? The references to FORCE_QUOTE look correct to me. The syntax
doesn't support multi-word option names, so it has to be like that
(or else run the words together, which doesn't sound like an
improvement).
regards, tom lane
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Underscorces in copy-documentation (9.0 and higher)
2013-03-20 10:48 Underscorces in copy-documentation (9.0 and higher) Mario Duhanic <[email protected]>
2013-03-20 14:05 ` Re: Underscorces in copy-documentation (9.0 and higher) Tom Lane <[email protected]>
@ 2013-03-20 14:49 ` Ian Lawrence Barwick <[email protected]>
2 siblings, 0 replies; 6+ messages in thread
From: Ian Lawrence Barwick @ 2013-03-20 14:49 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Mario Duhanic <[email protected]>; pgsql-docs
2013/3/20 Tom Lane <[email protected]>:
> Mario Duhanic <[email protected]> writes:
>> Hi,
>> - http://www.postgresql.org/docs/9.2/static/sql-copy.html,
>> - http://www.postgresql.org/docs/9.1/static/sql-copy.html and
>> - http://www.postgresql.org/docs/9.0/static/sql-copy.html
>
>> have underscores ("_") where there should be none,
>> e.g. in "FORCE_QUOTES".
>
> Huh? The references to FORCE_QUOTE look correct to me. The syntax
> doesn't support multi-word option names, so it has to be like that
> (or else run the words together, which doesn't sound like an
> improvement).
FWIW, multi-word option names are pre-9.0 syntax and still supported.
This is documented, albeit you have to scroll to the bottom of the page:
http://www.postgresql.org/docs/current/static/sql-copy.html#AEN66823
Regards
Ian Barwick
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 6+ messages in thread
* Fwd: Underscorces in copy-documentation (9.0 and higher)
2013-03-20 10:48 Underscorces in copy-documentation (9.0 and higher) Mario Duhanic <[email protected]>
2013-03-20 14:05 ` Re: Underscorces in copy-documentation (9.0 and higher) Tom Lane <[email protected]>
@ 2013-03-20 14:50 ` Mario Duhanic <[email protected]>
2 siblings, 0 replies; 6+ messages in thread
From: Mario Duhanic @ 2013-03-20 14:50 UTC (permalink / raw)
To: pgsql-docs
2013/3/20 Tom Lane <[email protected]>:
> Huh? The references to FORCE_QUOTE look correct to me. The syntax
> doesn't support multi-word option names, so it has to be like that
> (or else run the words together, which doesn't sound like an
> improvement).
Thanks, Tom, for your quick response.
Maybe this is just a miscommunication, sorry for that then (i.e. I
misunderstood the documentation here).
(Stupid) example for the problem:
"COPY (SELECT aggfnoid, aggtransfn from pg_aggregate) TO STDOUT WITH
FORCE QUOTE * DELIMITER ',' CSV HEADER;"
will run, a FORCE_QUOTE or FORCEQUOTE won't
(e.g. on a "PostgreSQL 9.2.3 on i386-portbld-freebsd9.1, compiled by
cc (GCC) 4.2.1 20070831 patched [FreeBSD]").
Best regards,
Mario
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Underscorces in copy-documentation (9.0 and higher)
2013-03-20 10:48 Underscorces in copy-documentation (9.0 and higher) Mario Duhanic <[email protected]>
2013-03-20 14:05 ` Re: Underscorces in copy-documentation (9.0 and higher) Tom Lane <[email protected]>
@ 2013-03-20 14:53 ` Tom Lane <[email protected]>
2013-03-20 15:01 ` Re: Underscorces in copy-documentation (9.0 and higher) Mario Duhanic <[email protected]>
2 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2013-03-20 14:53 UTC (permalink / raw)
To: Mario Duhanic <[email protected]>; +Cc: pgsql-docs
Mario Duhanic <[email protected]> writes:
> 2013/3/20 Tom Lane <[email protected]>:
>> Huh? The references to FORCE_QUOTE look correct to me. The syntax
>> doesn't support multi-word option names, so it has to be like that
>> (or else run the words together, which doesn't sound like an
>> improvement).
> Thanks, Tom, for your quick response.
> Maybe this is just a miscommunication, sorry for that then (i.e. I
> misunderstood the documentation here).
> (Stupid) example for the problem:
> "COPY (SELECT aggfnoid, aggtransfn from pg_aggregate) TO STDOUT WITH
> FORCE QUOTE * DELIMITER ',' CSV HEADER;"
> will run, a FORCE_QUOTE or FORCEQUOTE won't
As Ian notes, that's the old syntax with a hard-wired option set.
The lack of parentheses after WITH is the difference.
regards, tom lane
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Underscorces in copy-documentation (9.0 and higher)
2013-03-20 10:48 Underscorces in copy-documentation (9.0 and higher) Mario Duhanic <[email protected]>
2013-03-20 14:05 ` Re: Underscorces in copy-documentation (9.0 and higher) Tom Lane <[email protected]>
2013-03-20 14:53 ` Re: Underscorces in copy-documentation (9.0 and higher) Tom Lane <[email protected]>
@ 2013-03-20 15:01 ` Mario Duhanic <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Mario Duhanic @ 2013-03-20 15:01 UTC (permalink / raw)
To: pgsql-docs
2013/3/20 Tom Lane <[email protected]>
> As Ian notes, that's the old syntax with a hard-wired option set.
> The lack of parentheses after WITH is the difference.
Aarfh, thanks, guys!
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2013-03-20 15:01 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-03-20 10:48 Underscorces in copy-documentation (9.0 and higher) Mario Duhanic <[email protected]>
2013-03-20 14:05 ` Tom Lane <[email protected]>
2013-03-20 14:49 ` Ian Lawrence Barwick <[email protected]>
2013-03-20 14:50 ` Mario Duhanic <[email protected]>
2013-03-20 14:53 ` Tom Lane <[email protected]>
2013-03-20 15:01 ` Mario Duhanic <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox