Thread: 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?