discovering types

2020-08-12 Thread PG Doc comments 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


Re: discovering types

2020-08-12 Thread David G. Johnston
On Wednesday, August 12, 2020, PG Doc comments form 
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.