Re: Adding a colum - Mailing list pgsql-general

From jeam@themail.com
Subject Re: Adding a colum
Date
Msg-id 200007181436.JAA08111@winky.themail.com
Whole thread Raw
In response to Adding a colum  ("Steven" <lacroix@newwaveindustries.com>)
List 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



pgsql-general by date:

Previous
From: AVU Makerere
Date:
Subject: Postgresql and Postmaster response
Next
From: "Craig L. Ching"
Date:
Subject: RE: Postgresql and Postmaster response