--- List all of table a that intersects table b
select p.gid, p.name,c.district from public.working_poi as p join public.districts as c /
on st_intersects(p.geom, c.geom) order by p.name;

--- Update Geometry
SELECT UpdateGeometrySRID('roads','geom',4326);

--- Import SHP file with OGR and target projection
ogr2ogr -f "PostgreSQL" -t_srs EPSG:3435 -sql "SELECT DistrictName from Districts" /
PG:"dbname='mytable' user='username' password='userpassword'" -nln DistrictTableName /
-lco SCHEMA=public -lco OVERWRITE=YES -lco GEOMETRY_NAME=geom Districts.shp