postgresql - pgsql2shp - Export several part of table

Question

On PostgreSQL (and PgAdmin), i have a table which represents certain cities, and a column with 3 modalities.

name; modalitie; geometrie
name1; modalitie1; geom
name2; modalitie2; geom
name3; modalitie1; geom
name4; modalitie3; geom
name5; modalitie3; geom
.....

I would like to export this table in as many pieces as there are modalities in the column named "modalitie" (ex: "modalitie1.sql", "modalitie2.sql", etc). I was advised to use "pgsql2shp". I managed to export the whole table, but I couldn't cut it into several parts.

pgsql2shp -f pathoshape -u postgres -h localhost -P "0000" DB "select * from cities"

Is it possible to do this ?

Thank you.

question from:https://stackoverflow.com/questions/65934961/pgsql2shp-export-several-part-of-table

Answer 1

Waitting for answers