From: Rudi Starcevic <rudi@oasis.net.au>
To: pginfo <pginfo@t1.unisoftbg.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: changing column size and type.
Date: Wed, 16 Apr 2003 15:57:47 +1000
Message-ID: <3E9CF0DB.60509@oasis.net.au> (raw)
In-Reply-To: <3E9CDF76.C2B2D50@t1.unisoftbg.com>
References: <3E9C155B.7A694675@t1.unisoftbg.com>
<000401c303a4$b2d88500$7308a18e@cleartag>
<3E9CDF76.C2B2D50@t1.unisoftbg.com>
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: rudi@oasis.net.au, pginfo@t1.unisoftbg.com
Subject: Re: changing column size and type.
In-Reply-To: <3E9CF0DB.60509@oasis.net.au>
* 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