Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH j (geom) AS (
  VALUES ('SRID=32636;
          POLYGON((-1883435.029648588 6673769.700215263,-1883415.1158478875 6673776.142528819,-1883411.8478185558 6673765.073005969,-1883431.7724919873 6673758.967942359,-1883435.029648588 6673769.700215263))'::GEOMETRY)) 
SELECT 
  ST_Area(geom) AS sqm,
  ST_Area(
    ST_Transform(geom,2249)) AS sqft 
FROM j;


sqm
sqft


237.6060612927441
2341.135411239185


WITH j (geom) AS (
  VALUES ('SRID=32636;
          POLYGON((-1883435.029648588 6673769.700215263,-1883415.1158478875 6673776.142528819,-1883411.8478185558 6673765.073005969,-1883431.7724919873 6673758.967942359,-1883435.029648588 6673769.700215263))'::GEOMETRY)) 
SELECT 
  ST_Area(geom) AS sqm_32636,
  ST_Area(
    ST_Transform(geom,26986)) AS sqm_26986
FROM j;


sqm_32636
sqm_26986


237.6060612927441
217.49946676938265


WITH j (geom) AS (
  VALUES ('SRID=32636;
		  POLYGON((-1883435.029648588 6673769.700215263,-1883415.1158478875 6673776.142528819,-1883411.8478185558 6673765.073005969,-1883431.7724919873 6673758.967942359,-1883435.029648588 6673769.700215263))'::GEOMETRY)) 
SELECT 
  ST_Area(
    ST_Transform(geom,2249)) AS sqft_2249,
  ST_Area(
    ST_Transform(geom,2249)) * 0.3048 ^ 2 AS sqm_2249, -- manually converted from sqm to sqft
  ST_Area(
    ST_Transform(geom,26986)) AS sqm_26986
FROM j;


sqft_2249
sqm_2249
sqm_26986


2341.135411239185
217.49859675577048
217.49946676938265