By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,996 Members | 884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,996 IT Pros & Developers. It's quick & easy.

Oid to text...

P: n/a
Hi,

Given the Oid restype of a Resdom "object", is there any system table I
could query in order to retrieve the text representation of this type?

If for example a Resdom restype is 23 how can I get the string "integer"
or something like that? Are these mappings stored anyware?

Thanks in advance,
Ntinos Katsaros

PS: I searched the archives but my queries did not give anything...
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 22 Nov 2004 14:25:26 +0200, Katsaros Kwn/nos <nt****@aueb.gr> wrote:
Hi,

Given the Oid restype of a Resdom "object", is there any system table I
could query in order to retrieve the text representation of this type?

If for example a Resdom restype is 23 how can I get the string "integer"
or something like that? Are these mappings stored anyware?


pg_catalog.pg_type ?

Ian Barwick

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #2

P: n/a
"Katsaros Kwn/nos" <nt****@aueb.gr> writes:
Given the Oid restype of a Resdom "object", is there any system table I
could query in order to retrieve the text representation of this type?


If you're talking about C code inside the backend, format_type_be() is
the usual subroutine.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.