Christopher Kings-Lynne wrote:
> Hi,
>
> Would it be possible to add a new attribute to pg_views that stores the
> original view definition, as entered via SQL?
>
> This would make the lives of those of us who make admin interfaces a lot
> easier...
We actually reverse it on the fly:test=> \d xx View "xx" Column | Type | Modifiers
---------+------+-----------relname | name | View definition: SELECT pg_class.relname FROM pg_class;
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026