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 ?

Thanks in advance...

Carlos Savoretti.
----------------

Carlos Savoretti schrieb:
> Hi all!
>
> Well, question is how could I to retrieve information about
> types supported.


IMHO, no

--
Sebastian

On Tue, Mar 18, 2008 at 9:58 AM, Carlos Savoretti
<csavoretti@clubsanjorge.com.ar> 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/...-overview.html

--
Rob Wultsch