Page 1 of 1

How do you add fields to tables in PSQL?

Posted: Thu Apr 25, 2002 1:58 pm
by MattSharp
I was just wondering how can you can tables to an already existing field?

Add fields to existing table?

Posted: Fri Apr 26, 2002 11:02 pm
by captbrando
I assume you mean add fields to an existing table. This is done with the ALTER TABLE command. The syntax is as follows...

ALTER TABLE yourtable ADD COLUMN columname datatype

Posted: Sat Apr 27, 2002 12:39 pm
by MattSharp
Thanks. Yea, I need to work on my proofreading....