On Tue, Mar 18, 2008 at 9:58 AM, Carlos Savoretti <[EMAIL PROTECTED]> wrote: > Hi all! > > Well, question is how could I to retrieve information about > types supported . In PostgreSQL the query would be: > > ------------------------------------------------------------------ > SELECT pg_type.oid, typname, usename, obj_description(pg_type.oid) > FROM pg_type, pg_user > WHERE typowner=usesysid AND typrelid = 0 AND typname !~ '^_' > ------------------------------------------------------------------ > > Is there some way to obtain equivalent columns from INFORMATION_SCHEMA, > as similar as possible ? I do not think you can use the information schema to get this information. However you can use help:
For server side help, type 'help contents' mysql> help DATA TYPES You asked for help about help category: "Data Types" For more information, type 'help <item>', where <item> is one of the following topics: AUTO_INCREMENT BIGINT BINARY BIT BLOB BLOB DATA TYPE BOOLEAN CHAR CHAR BYTE DATE DATETIME DEC DECIMAL DOUBLE DOUBLE PRECISION ENUM FLOAT INT INTEGER LONGBLOB LONGTEXT MEDIUMBLOB MEDIUMINT MEDIUMTEXT SET DATA TYPE SMALLINT TEXT TIME TIMESTAMP TINYBLOB TINYINT TINYTEXT VARBINARY VARCHAR YEAR DATA TYPE mysql> help INT Name: 'INT' Description: INT[(M)] [UNSIGNED] [ZEROFILL] A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295. URL: http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
