pgadmin4 Add few missing PostgreSQL data types in query tool (RM #2473)

Issue migrated from Redmine: https://redmine.postgresql.org/issues/2473 Originally created by Khushboo Vashi at 2017-06-08 06:27:04 UTC.

Jun 08 '17 06:06 dpage

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2473#note-1 Originally created by Murtuza Zabuawala at 2017-12-29 10:42:19 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Relationship (relates) changed		RM #2576

Dec 29 '17 10:12 dpage

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2473#note-2 Originally created by Sander Eikelenboom at 2018-01-17 12:05:54 UTC.

Perhaps I'm mistaken, but the point type or an array thereof (and all other geometric types), don't seem like a PostGIS specific datatype to me, as they are available in normal Postgres without PostGIS extension.

Jan 17 '18 12:01 dpage

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2473#note-3 Originally created by Regina Obe at 2018-01-17 15:12:24 UTC.

point, lseg etc are NOT PostGIS types. Those are built-in PostgreSQL types that have existed since the dawn of PostgreSQL. So should probably go on a different ticket.

PostGIS types are geometry, geography, and raster.

Jan 17 '18 15:01 dpage

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2473#note-4 Originally created by Akshay Joshi at 2018-06-22 10:17:07 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed		Ready

Jun 22 '18 10:06 dpage

We have added all the supported data types adding a screenshot for ref:

Mar 19 '25 11:03 pravesh-sharma