From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Ivan Radovanovic <radovanovic(at)gmail(dot)com> |
Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Getting list of supported types in Postgres |
Date: | 2013-08-15 14:49:58 |
Message-ID: | 520CEA96.8000000@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 08/15/2013 07:37 AM, Ivan Radovanovic wrote:
> On 08/15/13 16:30, Adrian Klaver napisa:
>> On 08/15/2013 02:33 AM, Ivan Radovanovic wrote:
>>> On 08/15/13 05:23, Michael Paquier napisa:
>>>> On Thu, Aug 15, 2013 at 6:00 AM, Bruce Momjian<bruce(at)momjian(dot)us> wrote:
>>>>> Try psql -E, and run the \dT command to see the query it uses.
>>>> You have also the following commands:
>>>> - ¥dT+, all types with addition information like its size ('var' is
>>>> for example variable length)
>>>> - ¥dTS+, this includes also the catalog types
>>>>
>>>> Regards,
>>>
>>> Hi Michael and Bruce,
>>>
>>> Thank you for taking your time to reply.
>>>
>>> If I run \dTS+ that returns something that resembles information I need,
>>> but it is still missing info if type can have precision, and apparently
>>> aliases are missing (no decimal for numeric, no character for char and
>>> so on). Additionally it would be great if I could somehow also get
>>> information if type can be indexed.
>>>
>>> This doesn't have to come through SQL (I simply assumed that info can be
>>> obtained either from information schema or Postgress specific views and
>>> tables) - if you can point me to some source file that would be
>>> acceptable too :-)
>>
>> The docs would seem to be the place to go:
>>
>> http://www.postgresql.org/docs/9.2/interactive/datatype.html
>>
>>
>
> Thanks Adrian, sometimes we overlook most obvious solutions :-)
>
> Now I just need to find out which types can be indexed (and which types
> can be part of PK)
http://www.postgresql.org/docs/9.2/interactive/indexes.html
>
> Regards,
> Ivan
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Radovanovic | 2013-08-15 14:53:35 | Re: Getting list of supported types in Postgres |
Previous Message | Ivan Radovanovic | 2013-08-15 14:37:49 | Re: Getting list of supported types in Postgres |