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

Re: int4 to varchar length (pgadmin3) issue

From: <operationsengineer1(at)yahoo(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: int4 to varchar length (pgadmin3) issue
Date: 2006-08-31 18:41:05
Message-ID: 20060831184106.86238.qmail@web33311.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
> > iow, i want to limit the the newly converted
> varchar
> > revision to 2 characters, but can't due to the
> grayed
> > out boxes in pgadmin3.
> 
> I saw this example at:
>
http://www.postgresql.org/docs/8.1/interactive/sql-altertable.html
> 
> ALTER TABLE distributors ADD CONSTRAINT zipchk CHECK
> (char_length(zipcode) = 5);
> 
> This should do what you want.
> 
> Regards,
> 
> Richard Broersma Jr.
> 

Richard, thank you.  i think this does what i want,
however, i want to understand a bit more.

this is an additional defined constraint, correct?  is
this constraint added automagically by pgadmin when
you  enter a length value or is this a different
method to achieve a similar result?

tia..

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

In response to

Responses

pgsql-novice by date

Next:From: operationsengineer1Date: 2006-08-31 18:46:29
Subject: hyperlinks stored in pgsql
Previous:From: Richard Broersma JrDate: 2006-08-31 17:36:56
Subject: Re: int4 to varchar length (pgadmin3) issue

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