Feature request #680

add geographic columns to PostGIS

Added by venturato-faunalia-it - almost 16 years ago. Updated over 13 years ago.

Assignee:Marco Hugentobler
Category:Data Provider
Pull Request or Patch supplied: Resolution:fixed
Easy fix?:No Copied to github as #:10739


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.


#1 Updated by Giovanni Manghi over 13 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed


Postgis Manager is the answer. Closing this ticket.

Also available in: Atom PDF