pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedchanging the size of a varchar column
3+ messages / 3 participants
[nested] [flat]
* changing the size of a varchar column
@ 2004-09-08 16:45 Warren Little <wlittle@securitylending.com>
0 siblings, 1 reply; 3+ messages in thread
From: Warren Little @ 2004-09-08 16:45 UTC (permalink / raw)
To: pgsql-admin
Hello,
Does pg7.4.x support resizing a varchar column
ie varchar(30) -> varchar(200)
If not does the feature in 8.0 relating to changing column types support
this?
thx
--
Warren Little
Senior Vice President
Secondary Markets and IT Manager
Security Lending Wholesale, LC
www.securitylending.com
Tel: 866-369-7763
Fax: 866-849-8079
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: changing the size of a varchar column
@ 2004-09-08 17:22 Scott Marlowe <smarlowe@qwest.net>
parent: Warren Little <wlittle@securitylending.com>
0 siblings, 1 reply; 3+ messages in thread
From: Scott Marlowe @ 2004-09-08 17:22 UTC (permalink / raw)
To: Warren Little <wlittle@securitylending.com>; +Cc: pgsql-admin
On Wed, 2004-09-08 at 10:45, Warren Little wrote:
> Hello,
> Does pg7.4.x support resizing a varchar column
> ie varchar(30) -> varchar(200)
No, but some folks have done it by hacking the catalogs. not
recommended, make a backup, etc...
> If not does the feature in 8.0 relating to changing column types
> support this?
Yes.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: changing the size of a varchar column
@ 2004-09-08 21:34 Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
parent: Scott Marlowe <smarlowe@qwest.net>
0 siblings, 0 replies; 3+ messages in thread
From: Tsirkin Evgeny @ 2004-09-08 21:34 UTC (permalink / raw)
To: Scott Marlowe <smarlowe@qwest.net>; +Cc: Warren Little <wlittle@securitylending.com>; pgsql-admin
Maybe you already know this but the solution is to create a new
table with varchar(200) copy to it the data from the old one.
Then drop the old one and recreate with varchar(200) then copy
the data back from the tmp table.
Again you probably know all this ,just trying to help...
On Wed, 8 Sep 2004, Scott Marlowe wrote:
> On Wed, 2004-09-08 at 10:45, Warren Little wrote:
> > Hello,
> > Does pg7.4.x support resizing a varchar column
> > ie varchar(30) -> varchar(200)
>
> No, but some folks have done it by hacking the catalogs. not
> recommended, make a backup, etc...
>
> > If not does the feature in 8.0 relating to changing column types
> > support this?
>
> Yes.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Evgeny.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-09-08 21:34 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-08 16:45 changing the size of a varchar column Warren Little <wlittle@securitylending.com>
2004-09-08 17:22 ` Scott Marlowe <smarlowe@qwest.net>
2004-09-08 21:34 ` Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox