On Wed, Apr 30, 2014 at 11:06 AM, Rémi Cura <remi.c...@gmail.com> wrote:
> 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. > > If you have an older version you can use the mkfifo command to "trick" > postgres into believing he will copy from a file. > > 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 It's especially handy if you want to stay in sql(transaction), i gues. Cheers, -- Willy-Bas Loos
