Opened 17 years ago
Closed 15 years ago
#680 closed enhancement (fixed)
add geographic columns to PostGIS
Reported by: | Owned by: | mhugent | |
---|---|---|---|
Priority: | minor: annoyance | Milestone: | Version 1.0.3 |
Component: | Data Provider | Version: | Trunk |
Keywords: | Cc: | cavallini@… | |
Must Fix for Release: | No | Platform: | All |
Platform Version: | Awaiting user input: | no |
Description
It would be good to have a button for adding geographic columns to a postgis table, respecting OGC standard (thus updating also geometry_columns). To add an alphanumeric column, qgis must send to database 'ALTER TABLE tablename ADD COLUMN columnname typecolumn;', whereas to add a geometry it should send instead 'SELECT ADDGEOMETRYCOLUMN (<schema_name>, <table_name>, <column_name>, <srid>, <type>, <dimension>). Furthermore, it would be good to have a "delete column" button.
Note:
See TracTickets
for help on using tickets.
Hi!
Postgis Manager is the answer. Closing this ticket.