Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    18

    Unanswered: AddGeometryColumn

    Hi All

    I am trying to add a Geo Column to my table in a PostgreSQL environment so that i can map the places in QGIS.

    To Create the column I use the following statement

    Code:
    SELECT AddGeometryColumn( 'Table1', 'address_geom', 4326, 'POINT', 2 );
    I get the error

    ERROR: function addgeometrycolumn(unknown, unknown, integer, unknown, integer) does not exist

    HINT: No function matches the given name and argument types. You might need to add explicit type casts.
    Is there a plugin i need to add to the database in order for it to recognize the function

    Can anyone tell me how to do this (if its the case)

    Thank you very much for your time

  2. #2
    Join Date
    Feb 2013
    Posts
    18
    Hi All

    I managed to find the answer here

    You go to extensions and add postgis and postgis_topology and the code works without issue

    Thanks

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •