Home > mailing lists

CREATE OR REPLACE VIEW - Mailing list pgsql-sql

From	Ricardo Dias Marques
Subject	CREATE OR REPLACE VIEW
Date	November 21, 2000 17:14:26
Msg-id	3A1AC564.24FD6EA3@spamcop.net Whole thread Raw
List	pgsql-sql

Tree 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

pgsql-sql by date:

From: Tom Lane
Date: 21 November 2000, 16:19:11
Subject: Re: Problem with subquery joined to a view

From: Brian Powell
Date: 21 November 2000, 18:19:45
Subject: Permissions Broken in 7.0.x?

CREATE OR REPLACE VIEW - Mailing list pgsql-sql

Previous

Next