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  (Nicolas Thauvin <nicolas.thauvin@dalibo.com>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Reindexing primary keys without locking
Следующее
От: "Dai, Tino"
Дата:
Сообщение: Postgresql 8.2, tsearch2