Re: Adding a colum

From: jeam(at)themail(dot)com
To: lacroix(at)newwaveindustries(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Adding a colum
Date: 2000-07-18 14:36:42
Message-ID: 200007181436.JAA08111@winky.themail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Just use the SQL command:

ALTER TABLE tablename ADD fieldname FIELD TYPE SPECS;

Examples:

ALTER TABLE STUDENTS ADD BIRTHDAY DATE;
ALTER TABLE CUSTOMERS ADD CREDITLIMIT FLOAT4;

Regards, Jorge.
__________________________________________________________________
Make A Buck Or Two @ TheMail.com - Free Internet Email
Sign-up today at http://www.themail.com/ref.htm?ref=908313

Browse pgsql-general by date

  From Date Subject
Next Message Alex Bolenok 2000-07-18 15:00:42 Re: Migrating from MS SQL server
Previous Message Craig L. Ching 2000-07-18 14:14:38 RE: Postgresql and Postmaster response