Export binary data - PostgreSQL 9.2

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.lucas@gmail.com <drum.lucas@gmail.com>
wrote:

On 29 February 2016 at 06:31, Steve Crawford <scrawford@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.lucas@gmail.com <
drum.lucas@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.

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.lucas@gmail.com <drum.lucas@gmail.com>
wrote:

On 29 February 2016 at 06:31, Steve Crawford <
scrawford@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.lucas@gmail.com <
drum.lucas@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

-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 <abdulsayeed24@gmail.com>
wrote: