From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | "Braunstein, Alan" <alan_braunstein(at)mentor(dot)com> |
Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Exporting Table-Specified BLOBs Only? |
Date: | 2014-07-21 17:22:20 |
Message-ID: | CAECtzeXEo9mcoKqs-J0zPZUeH=eKeHi=SDHT3-Ya6On1T-+fUw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
2014-07-21 18:47 GMT+02:00 Braunstein, Alan <alan_braunstein(at)mentor(dot)com>:
> Is any Developer looking at this issue?
>
AFAICT, you want a new feature for pg_dump, not from pgAdmin. So you should
ask on pgsql-hackers, not pgadmin-support. And I don't think anyone is
working on this.
>
>
> *From:* pgadmin-support-owner(at)postgresql(dot)org [mailto:
> pgadmin-support-owner(at)postgresql(dot)org] *On Behalf Of *Braunstein, Alan
> *Sent:* Monday, April 28, 2014 1:05 PM
> *To:* pgadmin-support(at)postgresql(dot)org
> *Subject:* [pgadmin-support] Exporting Table-Specified BLOBs Only?
>
>
>
> *Fundamental issue:*
>
> PostgreSQL is different than Oracle in how it stores BLOBs
>
> http://www.postgresql.org/docs/9.1/static/catalog-pg-largeobject.html.
>
>
>
> *In PostgreSQL …*
>
> In the particular tables BLOBS are stored as OID’s (unique numbers).
>
> There is one table for all BLOB data (see pg_largeobject under
> Catalogs/PostgreSQL/pg_largeobject in pgadmin tree). It stores colums
> “OID/pageno/actual binary data (page)”.
>
>
>
>
>
> *What do I need?*
>
> A method of using pg_dump to selectively export BLOBs with OID’s used in
> the tables specified with --table <table_name1> --table <table_name2>
>
>
>
> I have four tables containing BLOBs I want to export w/o the BLOB data –
> that’s easy.
>
> What I also want is the remaining 200+ tables exported with THEIR BLOB
> entries, if any, but NOT one BLOB from the four tables explicitly *not*
> specified in pg_dump command; so JUST the BLOBs associated to any of the
> 200+ tables I do specify.
>
>
>
>
>
> Thanks!
>
> Alan
>
>
>
>
>
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Furry | 2014-07-21 18:53:08 | wxWidgets versioning |
Previous Message | Braunstein, Alan | 2014-07-21 16:47:56 | Re: Exporting Table-Specified BLOBs Only? |