Tony -- > When I issue: > > pg_dump newdb > /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2> > /DUMPDIR/newdb.log > > I get a dump of the entire dev schema. My goal is to dump the dev > schema minus the corgi table. How can I adjust my script to perform > this function? > > Thanks. Maybe the order of your arguments is causing some issues. This worked for me pg_dump -s -T product_feed_data staging_feed > sf.sql Where staging_feed is that database and product_feed_data is the table I excluded: grep product_feed_data sf.sql | grep -v product_feed_data_ COMMENT ON TABLE product_key IS 'A temporary table used to sync product_feed_data.does_exist_in_product. ... HTH, Greg Williamson -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
