I want the stupidest possible binary export
От | David Rysdam |
---|---|
Тема | I want the stupidest possible binary export |
Дата | |
Msg-id | 87oaudrpjo.fsf@loud.ll.mit.edu обсуждение исходный текст |
Ответы |
Re: I want the stupidest possible binary export
Re: I want the stupidest possible binary export Re: I want the stupidest possible binary export |
Список | pgsql-general |
I've got a some tables with bytea fields that I want to export only the binary data to files. (Each field has a gzipped data file.) I really want to avoid adding overhead to my project by writing a special program to do this, so I'm trying to do it from psql. Omitting the obvious switches for username, etc, here's what I'm doing: psql -t -c "\copy (select mybinaryfield from mytable where key = 1) to 'file'" That works, but I get escaped bytes. I want actual binary directly out of the DB. Another option might be: psql -t -c "\copy (select mybinaryfield from mytable where key = 1) to 'file'" with format binary However, there are two problems. First, I get an syntax error "at or near 'format'". (Running 9.2 client and server.) And second, I suspect that'll be some "proprietary" PG format, not the actual bytes from just my field. What option am I missing?
В списке pgsql-general по дате отправления: