Hi Jinqiang, Try: SELECT oid FROM pg_type WHERE typname='text';
You can always make that into a function. Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Jinqiang Han > Sent: Tuesday, 24 December 2002 10:00 AM > To: [EMAIL PROTECTED] > Subject: [HACKERS] about data type id > > > hello, > Is there a function that I can get type id from type name, such > as from 'text' to 25, 'int' to 23. > thanks in advance. > Jinqiang Han > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
