Search Postgresql Archives

Re: Getting list of supported types in Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx>
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?


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux