Skip site navigation (1) Skip section navigation (2)

FW: View column defaults in pgAdminIII

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: FW: View column defaults in pgAdminIII
Date: 2003-10-13 14:50:28
Message-ID: 03AF4E498C591348A42FC93DEA9661B84C5B0E@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 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 PageDate: 2003-10-13 15:17:00
Subject: Re: pgAdminIII bug
Previous:From: Donald FraserDate: 2003-10-13 14:49:25
Subject: Fw: View column defaults in pgAdminIII

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group