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

hello gurus

From: "Ganesh Rajan" <grajan(at)zeomega(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: hello gurus
Date: 2002-12-16 13:16:44
Message-ID: 003c01c2a505$614fe280$ (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
hello gurus,

iam facing a problem.... 
1) my database needed somechanges like increase in width for a varchar datatype column... since there is no option like using "ALTER TABLE ...." i have to drop the table & recreated.... so i did.... since the oid of this table is changed.... the tables & views referencing this table started to throw error...

what i did is that...i took the dump "pg_dump db_name > db_name.sql" .... and edited the script file & dont with the changes... 
is there any other way to change the structure...other than the way i done with..

2) i added another column to the table... now when i want to insert the value for this column the the dump script file... how to add the value for this column ...note: this column is my column in that table...

Please help required.....

Ganesh Rajan


pgsql-admin by date

Next:From: Mike BakerDate: 2002-12-16 15:52:19
Subject: Vacuum Question
Previous:From: HuubDate: 2002-12-16 08:54:16
Subject: Re: client for solaris

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