From: | Kevin Waterson <kevin(at)oceania(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Data types |
Date: | 2003-01-14 01:46:14 |
Message-ID: | 20030114124614.34ba1138.kevin@oceania.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I have been reading up on table creation with postgres but
cannot see anything on data types. I have been looking at
http://www.postgresql.org/idocs/index.php?tutorial-table.html
and if gives an example..
CREATE TABLE weather (
city varchar(80),
temp_lo int, -- low temperature
temp_hi int, -- high temperature
prcp real, -- precipitation
date date
);
what is real?
Is there a list of data types?
Kind regards
Kevin
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.fsf.org/philosophy/no-word-attachments.html
Kevin Waterson
Port Macquarie, Australia
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2003-01-14 01:58:49 | Re: Data types |
Previous Message | Josh Berkus | 2003-01-13 23:18:09 | Re: Had to drop some table columns, managed to annoy MS |