Re: [GENERAL] Export binary data - PostgreSQL 9.2

2016-03-04 Thread Koray Eyidoğan
-b/--blobs option should be required when making selective dumps. I just wanted to note for the sake of completeness. Have a nice day. On Thu, Mar 3, 2016 at 3:50 AM, Abdul Sayeed wrote: > Hi, > > You can use pg_dump with -t and -Fc option to take dump of a table in > compressed format. > > $PG

Re: [GENERAL] Export binary data - PostgreSQL 9.2

2016-03-02 Thread Abdul Sayeed
Hi, You can use pg_dump with -t and -Fc option to take dump of a table in compressed format. $PGBIN/pg_dump -t -Fc -d -f /tmp/table.dmp For more information you can refer below link: http://www.postgresql.org/docs/9.2/static/app-pgdump.html Hope this would help. On Thu, Mar 3, 2016 at 1:2

Re: [GENERAL] Export binary data - PostgreSQL 9.2

2016-03-02 Thread drum.lu...@gmail.com
On 29 February 2016 at 06:31, Steve Crawford wrote: > What exactly are you trying to do? Dump/backup your data (e.g. pg_dump)? > Read binary data from a table? If so, what field type (bytea, blob, ...)? > Export to where? > > Cheers, > Steve > > > On Sun, Feb 28, 2016 at 9:12 AM, drum.lu...@gmail

Re: [GENERAL] Export binary data - PostgreSQL 9.2

2016-02-28 Thread Steve Crawford
What exactly are you trying to do? Dump/backup your data (e.g. pg_dump)? Read binary data from a table? If so, what field type (bytea, blob, ...)? Export to where? Cheers, Steve On Sun, Feb 28, 2016 at 9:12 AM, drum.lu...@gmail.com wrote: > Hi all, > > > Which command would be to export the bi