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 is produce 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 alter the table using psql, which I know can be > done. What I'm not sure about is whether altering the table will also alter the > 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 <[EMAIL PROTECTED]> 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
pgp00000.pgp
Description: PGP signature
