Postgres Pro
Downloads
Home   >   mailing lists

Re: Listing views - Mailing list pgsql-general

From ra@konvergencia.hu
Subject Re: Listing views
Date
Msg-id 200408101328.08623.ra@konvergencia.hu
Whole thread Raw
In response to Listing views  (Olivier Guilyardi <ml@xung.org>)
Responses Re: Listing views
List pgsql-general
Tree view 
On Tuesday 10 August 2004 03:14, Olivier Guilyardi wrote:
> SELECT viewname FROM pg_views WHERE viewname !~ '^pg_';
with 7.4 :

SELECT viewname FROM pg_views WHERE schemaname NOT IN
('pg_catalog','information_schema');

Albert

pgsql-general by date:

Previous
From: Raphael Bauduin
Date:
Subject: history tables with only one function?
Next
From: "Rodríguez Rodríguez, Pere"
Date:
Subject: nested transaction