From: pginfo <pginfo@t1.unisoftbg.com>
To: Rudi Starcevic <rudi@oasis.net.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: changing column size and type.
Date: Wed, 16 Apr 2003 14:52:55 +0200
Message-ID: <3E9D5227.E346BAE0@t1.unisoftbg.com> (raw)
References: <3E9C155B.7A694675@t1.unisoftbg.com>
<000401c303a4$b2d88500$7308a18e@cleartag>
<3E9CDF76.C2B2D50@t1.unisoftbg.com>
<3E9CF0DB.60509@oasis.net.au>
<3E9D1F55.9582B0E6@t1.unisoftbg.com>
<20030416130931.M25027@oasis.net.au>
Hi Rudi,
I think it is good solution for now.
Many thanks,
ivan.
Rudi Starcevic wrote:
> Ivan,
>
> Oops sorry about that ..
> I should have read your email closer.
> Have you seen Joel Burton's doc at:
> http://techdocs.postgresql.org/techdocs/updatingcolumns.php
>
> Looks like you may need to use temporary tables and move
> the data back and forth.
>
> That's the way I do it.
> I'm pretty sure this also how it's done using the phpPgAdmin
> web admin tool.
> I guess since phpPgAdmin's a web tool the task is achieved 'online'.
>
> Cheers
> Best regards
> Rudi.
>
> > Hi Rudi,
> >
> > I readet the doc, but it is about how to ann new column.
> > That is well documented in pgDoc's.
> >
> > I will to change the column type of existing column.
> > For example if my columnt was declared as int4, I will to change it
> > to int8. Or if it was varchar(20) I will to make it varchar(100) and
> > so on. Also I will it without to dump the db.
> >
> > regards,
> > ivan.
> >
> > Rudi Starcevic wrote:
> >
> > > Ivan,
> > >
> > > This link show's how to do it online.
> > >
> > > http://www.edoceo.com/liberum/default.php?doc=postgresql-tricks
> > >
> > > There are other links around too.
> > >
> > > Cheers
> > > Rudi
> > >
> > >
> > > pginfo wrote:
> > >
> > >> Hi George,
> > >>
> > >> It is possible to do it so, but I wanted some better solution.
> > >> For example with oracle I can do it "online".
> > >>
> > >> regards,
> > >> ivan.
> > >>
> > >> George Weaver wrote:
> > >>
> > >>
> > >> > Hi Ivan,
> > >> >
> > >> > I don't know if this is a recommended practice or not, but you can
> > >> > try the
> > >> > following.
> > >> >
> > >> > Use PgDump to back up the entire database as a text file. Edit the
> > >> > backup
> > >> > text file and change the CREATE TABLE statement for the table you
> > >> > want to
> > >> > change, changing the column width to the new width desired.
> > >> > Restore the
> > >> > database. The database will be restored with the new width for the
> > >> > column
> > >> > in the table.
> > >> >
> > >> > The ability to do this depends on the size of the database, whether
> > >> > it can
> > >> > be taken off line, etc. etc.
> > >> >
> > >> > HTH
> > >> > George
> > >> >
> > >> > ----- Original Message -----
> > >> > From: "pginfo" <pginfo@t1.unisoftbg.com>
> > >> > To: <pgsql-sql@postgresql.org>
> > >> > Sent: Tuesday, April 15, 2003 9:21 AM
> > >> > Subject: [SQL] changing column size and type.
> > >> >
> > >> >
> > >> >> Hi,
> > >> >>
> > >> >> I am using pg 7.3.2.
> > >> >>
> > >> >> Is it possible to change:
> > >> >> - column size ot existing table.
> > >> >> - columnt size ( it is varchar basicaly).
> > >> >>
> > >> >> The problem is that the table have many freferences from and to
> > >> >> it.
> > >> >>
> > >> >> many thanks,
> > >> >> ivan.
> > >> >>
> > >> >>
> > >> >> ---------------------------(end of
> > >> >> broadcast)---------------------------
> > >> >> TIP 5: Have you checked our extensive FAQ?
> > >> >>
> > >> >> http://www.postgresql.org/docs/faqs/FAQ.html
> > >> >>
> > >> >>
> > >>
> > >> ---------------------------(end of
> > >> broadcast)---------------------------
> > >> TIP 5: Have you checked our extensive FAQ?
> > >>
> > >> http://www.postgresql.org/docs/faqs/FAQ.html
> > >>
> > >>
> > >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pginfo@t1.unisoftbg.com, rudi@oasis.net.au
Subject: Re: changing column size and type.
In-Reply-To: <3E9D5227.E346BAE0@t1.unisoftbg.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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