getting datatype of array elements

From: Moritz Sinn <moritz(at)freesources(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: getting datatype of array elements
Date: 2002-12-13 22:53:21
Message-ID: 87y96tmsym.fsf@appserv.sinnhq.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

--

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Iavor Raytchev 2002-12-14 00:44:57 Re: [GENERAL] PostgreSQL Global Development Group Announces
Previous Message Ken Godee 2002-12-13 22:35:32 Re: Copy/foreign key contraints