From: | Koray Eyidoğan <korayey(at)gmail(dot)com> |
---|---|
To: | Abdul Sayeed <abdulsayeed24(at)gmail(dot)com> |
Cc: | "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>, Steve Crawford <scrawford(at)pinpointresearch(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Export binary data - PostgreSQL 9.2 |
Date: | 2016-03-04 10:16:47 |
Message-ID: | CAOrEZugi4ih0KBffYSSt9JKUHE5ZmCQDAEw3ChW7m_JYpw=_og@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-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(at)gmail(dot)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(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)com
> > wrote:
>
>>
>>
>> On 29 February 2016 at 06:31, Steve Crawford <
>> scrawford(at)pinpointresearch(dot)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(dot)lucas(at)gmail(dot)com <
>>> drum(dot)lucas(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | s d | 2016-03-04 10:21:50 | Re: PLPythonu for production server |
Previous Message | Rémi Cura | 2016-03-04 10:02:33 | Re: bloated postgres data folder, clean up |