Dimitri Fontaine wrote:
> Le 7 mai 08 à 07:52, Tom Lane a écrit :
>
>> Dimitri Fontaine <dim@hi-media.com> writes:
>>> Could we consider ALTER VIEW ALTER COLUMN ... SET DEFAULT ...;?
>>
>> We could if we hadn't already done it five or so years ago.
>> Or am I missing what you need here?
>
> My 8.3.1 installation psql \h only gives me:
> Syntax:
> ALTER VIEW name RENAME TO newname

Ah, you use ALTER TABLE:

ALTER TABLE my_view ALTER COLUMN view_column DEFAULT expr;

--
Richard Huxton
Archonet Ltd

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers