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(at)cwgsy(dot)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.
pgadmin-support by date
|Next:||From: Dave Page||Date: 2003-10-13 15:17:00|
|Subject: Re: pgAdminIII bug|
|Previous:||From: Donald Fraser||Date: 2003-10-13 14:49:25|
|Subject: Fw: View column defaults in pgAdminIII|