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
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
