Thread: getting datatype of array elements

hi,

with the following statement, i get the datatype of a column with help of
its name and the tableoid:

SELECT typname FROM pg_attribute LEFT JOIN pg_type ON atttypid=typelem
WHERE attrelid=18210 AND attname='email';

but if the columns datatyp is an array, that doesn't work.
i'd like to get the basic datatype (the datatype of the array elements) then.

any ideas?

thanks,
 moritz

--

Moritz Sinn wrote:
> hi,
>
> with the following statement, i get the datatype of a column with help of
> its name and the tableoid:
>
> SELECT typname FROM pg_attribute LEFT JOIN pg_type ON atttypid=typelem
> WHERE attrelid=18210 AND attname='email';
>
> but if the columns datatyp is an array, that doesn't work.
> i'd like to get the basic datatype (the datatype of the array elements) then.

See typelem:
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/catalog-pg-type.html

HTH,

Joe