ALTER TABLE ADD COLUMN
On Thu, Jun 26, 2003 at 12:42:18PM -0400, MT wrote:
> Hello,
>
> I have a table with a bunch of records already inserted. When I want to add or remove fields from the, what I've done
isproduce an sql file, add the fields to the create table directive, and add the fields manually to each record to be
inserted.Then I do an
>
> \i db_name
>
> which destroys all the tables and records and then recreates them. I'm wondering if there's a better way. Namely, I
alterthe table using psql, which I know can be done. What I'm not sure about is whether altering the table will also
alterthe records, or will the records inserted previous to the alter table be out of sync with the table.
>
> Thanks for your advice.
>
> Mark
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
> - Samuel P. Huntington