Re: Quoted NULLs with COPY FROM (and pgAdmin export data

From: Richard Huxton <dev(at)archonet(dot)com>
To: George Pavlov <gpavlov(at)mynewplace(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Quoted NULLs with COPY FROM (and pgAdmin export data
Date: 2006-01-25 09:39:16
Message-ID: 43D74744.6030102@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Karin 2006-01-25 09:40:36 Please, help! About database cluster and adding to it additional disk space
Previous Message Richard Huxton 2006-01-25 09:36:20 Re: Shared Database across multiple servers using OCFS2