How to change the structure of tables with pgadmin2?

From: "NH-Jason" <jason(at)newhonest(dot)com(dot)hk>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: How to change the structure of tables with pgadmin2?
Date: 2002-01-31 07:47:34
Message-ID: 000a01c1aa2b$8bea7a80$2101a8c0@nht.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,
I'm an in-house VB programmer working with VB + Pg. pgAdmin2 is very valuable to me.

I have to change the tables' structures (add / delete column name, indexes; change data type ...) from time to time. I understand changing some of the schema thing is impossible with pg, so I will copy the SQL defination of the schema offered by pgAdmin2, drop the table, change the SQL defination and rebuild it. Everything's fine except all the data (mostly testing data) gone. Is there existing pgadmin / plug-in feature is able to do the job for me?

-Jason

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-01-31 08:28:00 Re: How to change the structure of tables with
Previous Message Dave Page 2002-01-30 22:17:46 Re: Default Values