Feature request #680

add geographic columns to PostGIS

Added by venturato-faunalia-it - about 17 years ago. Updated almost 15 years ago.

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 almost 15 years ago

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

Hi!

Postgis Manager is the answer. Closing this ticket.

Also available in: Atom PDF