Received: from europa.fcee.ucp.pt (europa.fcee.ucp.pt [158.162.130.125]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eALJ5Ls17639 for ; Tue, 21 Nov 2000 14:05:25 -0500 (EST) (envelope-from ricmarques@spamcop.net) Received: from spamcop.net ([158.162.130.58]) by europa.fcee.ucp.pt (8.9.3/8.9.3) with ESMTP id TAA02567 for ; Sat, 21 Nov 2020 19:11:04 GMT Message-ID: <3A1AC564.24FD6EA3@spamcop.net> Date: Tue, 21 Nov 2000 18:56:36 +0000 From: Ricardo Dias Marques X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: CREATE OR REPLACE VIEW Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/176 X-Sequence-Number: 207 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