Shapefile Import using GeoPandas

shp_import.py

from sqlalchemy import create_engine
import geopandas as gpd

user = "postgres"
password = "admin"
host = "localhost"
port = 5432
database = "postgis_in_action"

conn = f"postgresql://{user}:{password}@{host}:{port}/{database}"
engine = create_engine(conn)

#Read shapefile using GeoPandas
gdf = gpd.read_file("boundary_shp/boundary.shp")

#Import shapefile to databse
gdf.to_postgis(name="boundary", con=engine, schema="public")

print("success")