How to dump views definition in one schema?

Поиск
Список
Период
Сортировка
От Emi Lu
Тема How to dump views definition in one schema?
Дата
Msg-id 4A0C2CB5.6060707@encs.concordia.ca
обсуждение исходный текст
Список pgsql-sql
Good morning,

Can pg_dump or other command could dump all views definition in one schema.

I was trying to alter column types for several tables, and I have very 
complicated view dependencies.

What I try to do is:
(1). Back all views def
(2). alter columns
(3). re-create views from (1)

I'd like to know how to dump all views in one schema?

Thanks,

--
Lu Ying


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Distinct oddity
Следующее
От: Gary Stainburn
Дата:
Сообщение: update from join