Peter Eisentraut <[EMAIL PROTECTED]> writes:
> => create view testview as select relname, 'Constant'::text from pg_class;
I assume you meant SELECT DISTINCT there...
> => \d testview
>View "testview"
> Attribute | Type | Modifier
> ---+--+--
> relname | name |
>
=> create view testview as select relname, 'Constant'::text from pg_class;
=> \d testview
View "testview"
Attribute | Type | Modifier
---+--+--
relname | name |
?column? | text |
View definition: SELECT DISTINCT pg_class.relname, 'Constant'::text FROM
pg_class ORD
