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
