Opened 13 years ago
Closed 13 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: | |
| Cc: |
Description
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 , 13 years ago
| Milestone: | 1.9.0 |
|---|---|
| Resolution: | → wontfix |
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
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.