CREATE OR REPLACE VIEW

Поиск
Список
Период
Сортировка
От Ricardo Dias Marques
Тема CREATE OR REPLACE VIEW
Дата
Msg-id 3A1AC564.24FD6EA3@spamcop.net
обсуждение исходный текст
Список pgsql-sql
Hi all,

Is CREATE OR REPLACE VIEW available in any way, in PostgreSQL 7.0.2?

I am building a PHP/PostgreSQL application, and want to CREATE a VIEW if
it doesn't existe or REPLACE it with a new one, if it already exists. I
was hoping that I didn't have to DROP the VIEW so I don't get error
messages, and also, in my case, DROPping a view, when it doesn't already
exist is causing the PHP script to halt.

Any help is appreciated.

Ricardo Dias Marques
ricmarques@spamcop.net


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problem with subquery joined to a view
Следующее
От: Brian Powell
Дата:
Сообщение: Permissions Broken in 7.0.x?