Opened 11 years ago

Closed 11 years ago

#4243 closed enhancement (wontfix)

Include the complete table definition into PGDump

Reported by: zanollim Owned by: warmerdam
Priority: normal Milestone:
Component: OGR_SF Version: 1.8.1
Severity: normal Keywords:


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.

Change History (1)

comment:1 by Even Rouault, 11 years ago

Milestone: 1.9.0
Resolution: wontfix
Status: newclosed

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.

Note: See TracTickets for help on using tickets.