Adding a field to an existing table.
Adding a field to an existing table.
От:
"dlangschied" <dlangschied@ameritech.net>
Дата:
Hi! I found the doc on sequences and this will work for me. I am still curious, however, if you can simply add a field to a table without first dropping it. Sincerely, David Langschied Langschied Consulting Services 25644 Mackinac Roseville, MI 48066 Phone: (586)777-7542 Cell: (248)789-8493 e-mail: dlangschied@ameritech.net
Re: Adding a field to an existing table.
От:
"dlangschied" <dlangschied@ameritech.net>
Дата:
Thanks! Sincerely, David Langschied Langschied Consulting Services 25644 Mackinac Roseville, MI 48066 Phone: (586)777-7542 Cell: (248)789-8493 e-mail: dlangschied@ameritech.net ----- Original Message ----- From: "Brian Panulla" To: "dlangschied" Sent: Thursday, May 01, 2003 12:36 PM Subject: RE: [ADMIN] Adding a field to an existing table. > Sure.... check the docs on ALTER TABLE. You can add new fields to a table > and rename fields as well. I think the one thing you can't do is change data > type with an ALTER TABLE statement. You need to rename the field, add a new > one with the right data type, and migrate the data from old to new with a > query. > > Brian > > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of dlangschied > Sent: Thursday, May 01, 2003 12:32 PM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Adding a field to an existing table. > > > Hi! > I found the doc on sequences and this will work for me. I am still curious, > however, if you can simply add a field to a table without first dropping it. > > Sincerely, > > David Langschied > Langschied Consulting Services > 25644 Mackinac > Roseville, MI 48066 > > Phone: (586)777-7542 > Cell: (248)789-8493 > e-mail: dlangschied@ameritech.net > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html
