How do you add fields to tables in PSQL?
Moderator: General Moderators
How do you add fields to tables in PSQL?
I was just wondering how can you can tables to an already existing field?
- captbrando
- Forum Newbie
- Posts: 4
- Joined: Fri Apr 19, 2002 10:22 am
- Location: Dallas, TX
- Contact:
Add fields to existing table?
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
ALTER TABLE yourtable ADD COLUMN columname datatype