From: Nicolas Aragon <nyco@jet.es>
To: pgsql-interfaces@postgresql.org
Subject: types oids
Date: Tue, 17 Aug 1999 01:18:35 +0200
Message-ID: <19990817011835.A165@atlante> (raw)
Hello,
I'm programming with pqlib from Pascal (FPC) and trying to build some
classes to encapsulate result sets in a similar way as Delphi.
I need to know the type of every field and I've found that PQftype returns
an OID. OK, I can query pg_type system table and find out type information.
But this leads me to new questions because it seems that standard types
aren't hardcoded anywhere. pg_type tells me the name, size and some other
information about the type. But what about the "kind" of the type (numeric,
text, date...)?
I can only think of comparing the name with a list of names for standard
types. Is there another simpler method? A standard relation between standard
types and their OIDs?
If the answer to last question is "no", can I really trust at least the name?
If so, since I don't want to make the metadata query before each "regular"
query, I'll have to cache it. Is it OK to do it once per connection?
I can even think that.... is the user (admin) allowed to change the names
of standard types?
Another, more trivial question: do you know where to find nice logos
for postgres?
Thanks in advance
Nico
http://www.clubdelphi.com/nico/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: nyco@jet.es
Subject: Re: types oids
In-Reply-To: <19990817011835.A165@atlante>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox