Обсуждение: CREATE OR REPLACE VIEW

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

As a work around, you might get off telling php to ignore the
errors, using error_reporting();

CREATE OR REPLACE cannot be found in the postgres docs, so I
guess it is not there?

/Palle

Ricardo Dias Marques wrote:
> 
> Hi all,
> 
> Is CREATE OR REPLACE VIEW available in any way, in PostgreSQL 7.0.2?