Dimitri Fontaine wrote:
Le 7 mai 08 à 07:52, Tom Lane a écrit :
Dimitri Fontaine <[EMAIL PROTECTED]> 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
