Re: Can I read data load files without loading in db?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Can I read data load files without loading in db?
Дата
Msg-id 20060825115150.GF16535@svana.org
обсуждение исходный текст
Ответ на Can I read data load files without loading in db?  (barryc.ctr@gmail.com)
Ответы Re: Can I read data load files without loading in db?  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
On Fri, Aug 25, 2006 at 07:36:38AM -0400, barry conner wrote:
> Thanks for your reply Martijn.
>   I do not know for certain that its in pg_dump format, not having dealt
> with it specificly before.   I will examine the files more closely to look
> for COPY statements.   If not in that format, what else could it be that
> could be shoved right into a postgresql database?    In any case, would an
> associated file (schema type?) tell me the field name arrangements that the
> data files are loaded with?   or if COPY statements are used, would they
> name the fields being targeted?

It really depends on the format they send you. It's either plain text,
in which case the COPY commands will tell you which fields. If it's the
custom format you can use tar to extract it IIRC.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Can I read data load files without loading in db?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: invalid byte sequence ?