pg_dump and drop table if exists statement

Поиск
Список
Период
Сортировка
От Ibrahim Harrani
Тема pg_dump and drop table if exists statement
Дата
Msg-id BANLkTim45-uyjEQR5nL9kRBn0D0c_sJf7g@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump and drop table if exists statement
Список pgsql-admin
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.

В списке pgsql-admin по дате отправления: