You can use the postgis extension:
create extension postgis;
Then you can create a geography coulmn
location geography( point, 4326)
and insert a lat /long as a point like this:
ST_GeographyFromText('SRID=4326;POINT(%(longitude)s %(latitude)s)'),
On Tue, Oct 8, 2019 at 1:30 PM Andreas Kretschmer <[email protected]>
wrote:
>
>
> Am 08.10.19 um 12:50 schrieb Timmy Siu:
> > Now, I need Global Position System coordinates as a data type. How do
> > I define it in Postgresql 11 or 12?
>
> consider PostGIS.
>
>
> Regards, Andreas
>
> --
> 2ndQuadrant - The PostgreSQL Support Company.
> www.2ndQuadrant.com
>
>
>
>
