Include the complete table definition into PGDump

[zanollim]

Is it possible to include the whole table definition inside PGDump?

For example, my table (postgis layer) defines some GRANT instruction and a COMMENT. If I export this table into sql with PGDump driver, the comment (COMMENT ON...) and the access privileges instructions (GRANT SELECT..., GRANT ALL...) are lost and are to be recreated manually in the new database/schema.

[rouault]

There's no way the PGDump driver can access to the permissions or comment. The main reason is that it has no idea that your input dataset is actually a Postgis layer. It could as well be a shapefile or whatever input formats OGR can handle.

It sounds like you just need to do a database dump with the appropriate PostgreSQL utility.