Hi, I am using PostgreSQL 9.0 I would like to dump some tables and all functions,triggers on the database. If I drop with pg_dump -c parameter, it removes public schema as well. pg_dump -C parameter output has create table but I can't restore this output directly(Because the tables are already exist on the db) There is no problem with functions. They have already this feature.
How can backup/restore tables with DROP TABLE IF EXISTS statement like in MySQL? without dropping all database and create again? Thanks in advance. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
