Tried the following command but got error:
ST_Transform(ST_SetSRID(ST_Point(lon , lat), 4326), 2163) As geom
ERROR: could not form projection (LWPROJ) from 'srid=4326' to 'srid=2163'
Runnning postgis_full_version(); gives the following output
POSTGIS="3.2.0 c3e3cc0" [EXTENSION] PGSQL="130" GEOS="3.10.1-CAPI-1.16.0" PROJ="6.3.1" LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"