Data types

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

Responses

Browse pgsql-novice by date

  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