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:demolish@cwgsy.net]
> > 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.