Ankur Kaushik wrote: > So is there any way to restore database without any error , or Can we put one line in database backup > file , DROP TABLE 'table name' just before CREATE TABLE. You mean like the -c option in pg_dump or pg_restore? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin