Magnus Hagander wrote:
On Thu, Sep 3, 2009 at 13:31, Andrew Dunstanand...@dunslane.net wrote:
Magnus Hagander wrote:
Oh, hang on, the NULL string refers to the copy parameter? Not a
part of the data? I read it as a string being NULL. Maybe something
like the value of the NULL string
Bruce Momjian wrote:
Magnus Hagander wrote:
On Thu, Sep 3, 2009 at 13:31, Andrew Dunstanand...@dunslane.net wrote:
Magnus Hagander wrote:
Oh, hang on, the NULL string refers to the copy parameter? Not a
part of the data? I read it as a string being NULL. Maybe something
like
Andrew Dunstan wrote:
Bruce Momjian wrote:
Magnus Hagander wrote:
On Thu, Sep 3, 2009 at 13:31, Andrew Dunstanand...@dunslane.net wrote:
Magnus Hagander wrote:
Oh, hang on, the NULL string refers to the copy parameter? Not a
part of the data? I read it as a
Crap, I just realized I sent to pgadmin hackers by mystake. Meh.
Our documentation for COPY
(http://www.postgresql.org/docs/8.4/static/sql-copy.html) has the
following to say:
The CSV format has no standard way to distinguish a NULL value from
an empty string. PostgreSQL's COPY handles this
Magnus Hagander wrote:
Our documentation for COPY
(http://www.postgresql.org/docs/8.4/static/sql-copy.html) has the
following to say:
The CSV format has no standard way to distinguish a NULL value from
an empty string. PostgreSQL's COPY handles this by quoting. A NULL is
output as the NULL
On Thu, Sep 3, 2009 at 13:19, Andrew Dunstanand...@dunslane.net wrote:
Magnus Hagander wrote:
Our documentation for COPY
(http://www.postgresql.org/docs/8.4/static/sql-copy.html) has the
following to say:
The CSV format has no standard way to distinguish a NULL value from
an empty
Magnus Hagander wrote:
Oh, hang on, the NULL string refers to the copy parameter? Not a
part of the data? I read it as a string being NULL. Maybe something
like the value of the NULL string parameter to be overly clear for
people like me? :-)
We could change:
A NULL is output as the
On Thu, Sep 3, 2009 at 13:31, Andrew Dunstanand...@dunslane.net wrote:
Magnus Hagander wrote:
Oh, hang on, the NULL string refers to the copy parameter? Not a
part of the data? I read it as a string being NULL. Maybe something
like the value of the NULL string parameter to be overly clear