On 08/15/13 16:49, Adrian Klaver napisa:
> 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@momjian.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
>
doesn't list which types can be indexed and which can't?
