Re: GPS coordinates problem

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 <andreas(at)a-kretschmer(dot)de>
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
>
>
>
>