Latitude/longitude from PostGIS table with coordinates transformation not working

Question

I have a PostGIS (PostgreSQL 13/PostGIS 3.1.1 on Debian 11.7) table with points in EPSG:6708, so it's plain coordinates (data from Northern Italy). I need to get lat/long coordinates, so I do:

    SELECT ST_AsText(the_geom) AS xy, ST_AsText(ST_Transform(the_geom,4326)) AS ll FROM acq_impianti WHERE gid=426;
                         xy                     |                    ll                     
    --------------------------------------------+-------------------------------------------
     POINT(291349.5482259364 5072882.274108588) | POINT(52.9750863624063 2.074122662821441)

which is absolutely wrong; in fact if I do the same transformation using this tool, I obtain:

I can't figure out what I'm doing wrong....

EDIT: Using ST_FlipCoordinates solves the problem, but maybe there is a better way to handle this

SELECT ST_AsText(the_geom) AS xy, ST_AsText(ST_Transform(ST_FlipCoordinates(the_geom),4326)) AS ll FROM acq_impianti WHERE gid=426;                     xy                     |                     ll                      
--------------------------------------------+---------------------------------------------
 POINT(291349.5482259364 5072882.274108588) | POINT(12.316072170259908 45.77796903086367)

Answer 1

You can swap the X & Y coordinates like this:

UPDATE your_table
SET your_geom_column = ST_SetSRID(ST_MakePoint(ST_Y(your_geom_column ), ST_X(your_geom_column )), ST_SRID(your_geom_column))
WHERE your_condition = whatever;

Hope it helps my friend. In geom