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

From dlangschied
Subject Re: Adding a field to an existing table.
Date
Msg-id 004601c31000$45627270$6401a8c0@lcshost
Whole thread Raw
In response to Adding a field to an existing table.  ("dlangschied" <dlangschied@ameritech.net>)
List pgsql-admin
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" <brian@elmwoodmedia.com>
To: "dlangschied" <dlangschied@Ameritech.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@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


pgsql-admin by date:

Previous
From: "dlangschied"
Date:
Subject: Adding a field to an existing table.
Next
From: Stephan Szabo
Date:
Subject: Re: Adding a field to an existing table.