discovering types

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

discovering types

PG Bug reporting form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/datatype.html
Description:

Thank you for perfect documentation. Please add subchapter about discovering
types. Themes like List all available types, Get type of column with
pg_typeof() function, with sql into information_schema.columns, with psql \d
command etc.,
https://stackoverflow.com/questions/3827828/how-to-check-type-of-value-in-postgres.
Thank you in advance, Hans
Reply | Threaded
Open this post in threaded view
|

Re: discovering types

David G Johnston
On Wednesday, August 12, 2020, PG Doc comments form <[hidden email]> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/datatype.html
Description:

Thank you for perfect documentation. Please add subchapter about discovering
types. Themes like List all available types, Get type of column with
pg_typeof() function, with sql into information_schema.columns, with psql \d
command etc.,
https://stackoverflow.com/questions/3827828/how-to-check-type-of-value-in-postgres.
Thank you in advance, Hans

Doesn’t seem worth the effort.  The documentation is the best discovery resource while whatever admin tool one uses, psql in core, provides info about schema columns.  pg_typeof is documented but seldom useful.  Maybe a cross-reference to it is warranted elsewhere but adding a complete sub-section for this topic seems a bit much.

If one were to submit such a patch I’d consider it but its not something that I consider as a existing omission.

David J.