Vincent Veyron <vv.li...@wanadoo.fr> wrote: > On Fri, 1 May 2015 14:12:08 +0000 > Alanoly Andrews <alano...@invera.com> wrote: > > > Hello, > > > > We have a database that has been unloaded using pg_dump. This database has > > a table with a field defined as "lo". When restoring this database to > > another system, we want to avoid loading this particular table as it is > > very large (about 8GB of blob data) and is not needed on the target system. > > I tried the following: > > 1. Create a list of all the tables in the pg_dump file using the -l > > option of pg_restore > > 2. Edit out the lines corresponding to the said table (with the "lo" > > column) > > 3. Run the pg_restore with the -L option to use the edited list of > > tables. > > > > use the -T option of pg_dump?
i think, this isn't a solution. i HAVE a complete dump, but now i need a restore without the lo - data. And - you can't create a new dump with -T for several reasons now. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
