-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 <abdulsayee...@gmail.com> wrote: > Hi, > > You can use pg_dump with -t and -Fc option to take dump of a table in > compressed format. > > $PGBIN/pg_dump -t <TABLE_NAME> -Fc -d <DATABASE_NAME> -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:21 AM, drum.lu...@gmail.com <drum.lu...@gmail.com > > wrote: > >> >> >> On 29 February 2016 at 06:31, Steve Crawford < >> scrawf...@pinpointresearch.com> 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.com < >>> drum.lu...@gmail.com> wrote: >>> >>>> Hi all, >>>> >>>> >>>> Which command would be to export the binary data for a table? >>>> >>>> I was unable to find it... >>>> >>>> Thanks >>>> >>> >>> >> >> Have just used the COPY .... WITH Binary >> >> Thank you. >> > > > > -- > Thanks & Regards, > Abdul Sayeed > PostgreSQL DBA > Postgres Professional Certified > EnterpriseDB Corp > Skype: abdul.sayeed24 >
