Postgres Pro
Downloads
Home   >   mailing lists

Re: Quoted NULLs with COPY FROM (and pgAdmin export data - Mailing list pgsql-general

From Richard Huxton
Subject Re: Quoted NULLs with COPY FROM (and pgAdmin export data
Date
Msg-id 43D74744.6030102@archonet.com
Whole thread Raw
In response to Re: Quoted NULLs with COPY FROM (and pgAdmin export data options)  ("George Pavlov" <gpavlov@mynewplace.com>)
List pgsql-general
Tree view 
George Pavlov wrote:
>
> This is actually turning into a bit of a pgAdmin issue: pgAdmin lets you
> export data in a format that seems to be unimportable back into the same
> table. If in the "Export data to file" form you check "all columns"
> under "Quoting" you will get quotes around your numeric NULLs that you
> will be unable to import back using COPY without resorting to
> preprocessing of some sort (unless someone tells me how COPY can use
> quoted NULLs).

Does sound like something for the pgadmin team.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Shared Database across multiple servers using OCFS2
Next
From: Sergey Karin
Date:
Subject: Please, help! About database cluster and adding to it additional disk space