Thread: Adding a field to an existing table.

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

On Thu, 1 May 2003, dlangschied wrote:

> I want to know if it is possible to add a field to an existing table.  I

With some limitations about extra clauses (constraints, defaults) being
dropped on some versions, ALTER TABLE ADD COLUMN can add fields.