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

Reply via email to