Re: Adding a field to an existing table.

Thanks!

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
----- Original Message -----
From: "Brian Panulla" <brian(at)elmwoodmedia(dot)com>
To: "dlangschied" <dlangschied(at)Ameritech(dot)Net>
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(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of dlangschied
> Sent: Thursday, May 01, 2003 12:32 PM
> To: pgsql-admin(at)postgresql(dot)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(at)ameritech(dot)net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html