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

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Quoted NULLs with COPY FROM (and pgAdmin export data
Дата
Msg-id 43D74744.6030102@archonet.com
обсуждение исходный текст
Ответ на Re: Quoted NULLs with COPY FROM (and pgAdmin export data options)  ("George Pavlov" <gpavlov@mynewplace.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Shared Database across multiple servers using OCFS2
Следующее
От: Sergey Karin
Дата:
Сообщение: Please, help! About database cluster and adding to it additional disk space