Data types mapping - Mailing list pgsql-novice

From Doug Silver
Subject Data types mapping
Date
Msg-id 200304101055.56609.dsilver@urchin.com
Whole thread Raw
Responses Re: Data types mapping  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
I have a partial mapping of some of the fields with their internal type, e.g.:

integer    4
smallint    5
bigint    8
date        9
varchar    12
boolean    16
text        25

What internal table has the complete mapping?  I looked around on the Postgres
site and thought it might be in pg_attribute, pg_attrdef, or pg_type, but
it's not -- or else I'm not performing the right query.

Thanks.

-doug

ps - These values are "set in stone" and don't change with updates, correct?


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: connect to database over network
Next
From: Tom Lane
Date:
Subject: Re: Data types mapping