Re: [SPAM] COPY command & binary format
| От | Nicolas Paris |
|---|---|
| Тема | Re: [SPAM] COPY command & binary format |
| Дата | |
| Msg-id | CA+ssMOSVC-Yu+yQXeLHL3c0+iz4g1PEtRM49cVvQxyNFN3d4sA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [SPAM] COPY command & binary format (Moreno Andreo <moreno.andreo@evolu-s.it>) |
| Ответы |
Re: [SPAM] COPY command & binary format
Re: [SPAM] COPY command & binary format |
| Список | pgsql-general |
2016-05-10 13:04 GMT+02:00 Moreno Andreo <moreno.andreo@evolu-s.it>:
Il 10/05/2016 12:56, Nicolas Paris ha scritto:I always create binary files withHello,What is the way to build a binary format (instead of a csv) ? Is there specification for this file ?
http://www.postgresql.org/docs/9.5/static/sql-copy.html
COPY table TO 'path/to/file' WITH BINARY
Fine, this works in this way :
postgresql -> binary
postgresql -> binary
binary -> postgresql
The way I want is :
csv -> binary -> postgresql
And if possible, transforming csv to binary throught java.
Use case is ETL process.
В списке pgsql-general по дате отправления: