Josh.Zeckser@xxxxxxxxxxxx writes: > pgsql-admin-owner@xxxxxxxxxxxxxx wrote on 10/25/2005 02:31:51 AM: >> It's possible with pg_restore to exclude that table on /restore/, but >> that's not what you asked for.. >> >> On 25.10.2005 11:08, Gourish Singbal wrote: >> > pg_dump does not allow you to accomplish this task for sure. >> > >> > On 10/20/05, Colton A Smith <smith@xxxxxxxxxx> wrote: >> >> I don't think this is possible, but I want to make sure. Let's say I >> >> have a database that I want to dump in its entirety, all except for one >> >> particular table. Is there an option flag on pg_dump that accomplishes >> >> this? > Here is an option: Dump into a test database, drop the table in the > test db & dump to file: pg_dump originaldb | psql testdb < > droptable.sql; pg_dump testdb > dumpfile A usual reason why I would want to dump everything except for a few tables is that those few tables are particularly enormous and particularly useless (at least, for the purposes of my dump). In that case, the LAST thing I want to do is to make extra copies of the *useless* tables. By the way, it is quite likely that the above approach would be more quickly accomplished via using originaldb as a template for testdb. Thus... $ createdb --template=originaldb testdb $ for tables in t1 t2 t3 t4 t4; do > psql -d testdb -c "drop table public.t1;" done $ pg_dump testdb > dumpfile $ dropdb testdb -- "cbbrowne","@","cbbrowne.com" http://www3.sympatico.ca/cbbrowne/finances.html "Wow! You read advocacy groups once in a while, thinking you'll find the occasional gem, but when you unearth the Taj Mahal you still have to stand back and gape a little." -- Paul Phillips <paulp@xxxxxxxxxx> ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
