Re: pg_views.definition

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