I have figured out (through the use of this thread) on how to go from a file GDB to posgreSQL using ogr2ogr. Now what I want to do is import all the feauture classes but change the geometry column to geom.
ogr2ogr -f "PostgreSQL" PG:"host=localhost port=5432 dbname=freelance user=postgres" C:\pathto\oakland.gdb -overwrite -progress
when i run this cmd ogr2ogr command it correctly imports the feature classes into postgresql but the geometry column annoyingly gets renamed to wkb_geometry. I believe there is a way to alter a column for an individual layer but how do you do it for all feature classes?
although I know its recommended to ask this in a new question but if I wanted to project/transform to another SRID while importing into PostgreSQL how would I accomplish this