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 11:16:05 +0200
Message-ID: <3E9D1F55.9582B0E6@t1.unisoftbg.com> (raw)
References: <3E9C155B.7A694675@t1.unisoftbg.com>
<000401c303a4$b2d88500$7308a18e@cleartag>
<3E9CDF76.C2B2D50@t1.unisoftbg.com>
<3E9CF0DB.60509@oasis.net.au>
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
>>
>>
>
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: <3E9D1F55.9582B0E6@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