Forgot to CC the list... > -----Original Message----- > From: Dave Page > Sent: 13 October 2003 15:49 > To: 'Donald Fraser' > Subject: RE: [pgadmin-support] View column defaults in pgAdminIII > > > > > -----Original Message----- > > From: Donald Fraser [mailto:[EMAIL PROTECTED] > > Sent: 13 October 2003 15:27 > > To: Dave Page > > Subject: Re: [pgadmin-support] View column defaults in pgAdminIII > > > > Sorry but I believe you are mistaken on this one. > > Wouldn't be the first time! > > > For example to set the default value of a column of a view > you issue > > the command which is very similar to that of a table: > > Example: ALTER TABLE vu_someview ALTER COLUMN b_somecolumn > SET DEFAULT > > '0'; > > Useful for updateable views. I'll add it to the todo... > > Regards, Dave.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html