Adding a field to an existing table. - Mailing list pgsql-admin

From dlangschied
Subject Adding a field to an existing table.
Date
Msg-id 002701c30ffd$c4043b20$6401a8c0@lcshost
Whole thread Raw
Responses Re: Adding a field to an existing table.  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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@ameritech.net


pgsql-admin by date:

Previous
From: "Ramesh PAtel "
Date:
Subject: DAte use in For loop
Next
From: "dlangschied"
Date:
Subject: Adding a field to an existing table.