Re: importing a messy text file
| От | Willy-Bas Loos |
|---|---|
| Тема | Re: importing a messy text file |
| Дата | |
| Msg-id | CAHnozTgmzDWsz+-3-g2W=UnhBAYTuBXAaUQb8w1m_6Rn_DHDXQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: importing a messy text file (Rémi Cura <remi.cura@gmail.com>) |
| Ответы |
Re: importing a messy text file
|
| Список | pgsql-general |
On Wed, Apr 30, 2014 at 11:06 AM, Rémi Cura <remi.cura@gmail.com> wrote:
If you have an older version you can use the mkfifo command to "trick" postgres into believing he will copy from a file.with latest version 9.3 you can use a copy from with a programm as argument.You can use the unix | pipe for most of the stuff.
Hi, you're right i can see the new feature in the docs.
But since i am working from the (bash) command line already, i don't see any use for this.
I already pass the data like this:
cat <file> |psql -c "copy <table> from stdin NULL ''" <db> > <file>.log 2>&1
cat <file> |psql -c "copy <table> from stdin NULL ''" <db> > <file>.log 2>&1
It's especially handy if you want to stay in sql(transaction), i gues.
Cheers,
--
Willy-Bas Loos
В списке pgsql-general по дате отправления: