I have created a Geodataframe from a PostgreSQL table with the following instruction (where 'con' is a psycopg2 connection):
gdf = gpd.GeoDataFrame.from_postgis("SELECT id, geom FROM {0}".format('pg_table'), con=con, geom_col='geom')
I have then processed the Geodataframe and I would like to load the result into a new table in PostgreSQL. However, I don't seem to find an equivalent instruction to 'from_postgis' (something like 'to_postgis' or similar). I have read a post about some SQLAlchemy, which seems over-complicated and I must admit I have not understood. Just wondering whether there's any simple way to do what I'm trying to do?