Hey everyone, New to Supabase here but I assume this is pretty straightforward. I have a database that already has a latitude and longitude column and I want to be able to sort them by location. I already have PostGIS enabled, so is there an SQL command I can run to copy the data from these two columns and add them to a new location column?

in general you just use an update,

update mytable set newcol=oldcol

. The specifics of what you need depends on what the column type of your new column is. We can infer that the lat/lon are floats.

Yes they’re both floats. How do take “col1” + “col2” and combine into a new column?

Have you googled

postgis convert lat lon columns to single

or something like that. I see lots of hits. Postgis supports different types of columns to depending on things like using geometry or geography, etc. https://gis.stackexchange.com/questions/145007/creating-geometry-from-lat-lon-in-table-using-postgis First hit I got, there were many