Adding a field to an existing table.

From: "dlangschied" <dlangschied(at)ameritech(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Adding a field to an existing table.
Date: 2003-05-01 16:21:47
Message-ID: 002701c30ffd$c4043b20$6401a8c0@lcshost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi again,
I want to know if it is possible to add a field to an existing table. I
know I can drop the table and add it back, but that may not always be
desireable. I am trying to convert a Progress database to postgres. The
sequences are separate from the tables in Progress and they are serial
fields in postgres. The easiest solution is to add the sequences as serial
fields to the postgres database, after the tables have been created. This
would certainly be a pain in the #*#^$& if I had to create these serial
fields when I create the table. I am trying to achieve a totally hands off
conversion of the database, but this particular issue has me concerned.

Sincerely,

David Langschied
Langschied Consulting Services
25644 Mackinac
Roseville, MI 48066

Phone: (586)777-7542
Cell: (248)789-8493
e-mail: dlangschied(at)ameritech(dot)net

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message dlangschied 2003-05-01 16:31:49 Adding a field to an existing table.
Previous Message Ramesh PAtel 2003-05-01 11:30:05 DAte use in For loop