Thread: pg_dump feature request: Exclude tables?
Since pg_dump will be allowing multiple -t <table> parameters for 8.0, here is a related feature request. A similar option (allowing multiples also) to EXCLUDE tables, so we can do a dump of the entire database minus a few tables. Glen Parker glenebob@nwlink.com
Glen Parker wrote: > Since pg_dump will be allowing multiple -t <table> parameters for 8.0, here > is a related feature request. Nope, didn't make it into 8.0. > A similar option (allowing multiples also) to EXCLUDE tables, so we can do a > dump of the entire database minus a few tables. Yes, we have talked about that. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Bruce Momjian wrote: >Glen Parker wrote: > > >>Since pg_dump will be allowing multiple -t <table> parameters for 8.0, here >>is a related feature request. >> >> > >Nope, didn't make it into 8.0. > > > >>A similar option (allowing multiples also) to EXCLUDE tables, so we can do a >>dump of the entire database minus a few tables. >> >> > >Yes, we have talked about that. > > > This would be a big plus for one of our projects too. Is it on some TODO list for a future release? Ron
Ron St-Pierre wrote: > Bruce Momjian wrote: > > >Glen Parker wrote: > > > > > >>Since pg_dump will be allowing multiple -t <table> parameters for 8.0, here > >>is a related feature request. > >> > >> > > > >Nope, didn't make it into 8.0. > > > > > > > >>A similar option (allowing multiples also) to EXCLUDE tables, so we can do a > >>dump of the entire database minus a few tables. > >> > >> > > > >Yes, we have talked about that. > > > > > > > This would be a big plus for one of our projects too. Is it on some TODO > list for a future release? No, we have: * Allow pg_dump to use multiple -t and -n switches This should be done by allowing a '-t schema.table' syntax. but that doesn't have the exclude option. We had a patch that implemented an exclude but got confused over how it would interact with the schema switch and stuff. However, with the new '-t schema.table' syntax we might be able to get it working. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
I second this. I would prefer an option to dump only the schema of certain tables rather than excluding them altogether. Paul Glen Parker wrote: >Since pg_dump will be allowing multiple -t <table> parameters for 8.0, here >is a related feature request. > >A similar option (allowing multiples also) to EXCLUDE tables, so we can do a >dump of the entire database minus a few tables. > >Glen Parker >glenebob@nwlink.com > > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings > > > >