Feature request #680
add geographic columns to PostGIS
Status: | Closed | ||
---|---|---|---|
Priority: | Low | ||
Assignee: | Marco Hugentobler | ||
Category: | Data Provider | ||
Pull Request or Patch supplied: | Resolution: | fixed | |
Easy fix?: | No | Copied to github as #: | 10739 |
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.
History
#1 Updated by Giovanni Manghi about 15 years ago
- Resolution set to fixed
- Status changed from Open to Closed
Hi!
Postgis Manager is the answer. Closing this ticket.