locked
postgres RRS feed

  • Question

  • User736276958 posted

    hi all

    iam using postgres database

    in my table there is a geometry column(columname is geom)

    for retrieving geom data iam using a select statement as

    select geom from table

    but iam not getting any data, column is displayin as empty

    so please tell me the query to get geom data

    i am able to display the area, box...........

    but these are displaying as coord

    i want exact geom data as 15245565asa21635635sasa525

    Thursday, June 11, 2015 2:01 AM

All replies

  • User-271186128 posted

    Hi rishe28,

    for retrieving geom data iam using a select statement as

    select geom from table

    but iam not getting any data, column is displayin as empty

    From your description, I suggest you could set a break point to check the query result.

    If the result is Null, I suppose the error is related to the select statement. Please check the table name and the DataTable in Database, make sure the table name is right and this column contains values.

    If the result is not Null, I suppose the issue is not related to the SQL query, please check the Client/Server side code, and check the code about binding this column.

    If possible I suggest you could post some relevant code (such as: query database, bind data to data control, and client side code), it might be easier for us to guide you and help you.

    Here is an article about PostgreSQL Query, you could refer to it:

    http://www.tutorialspoint.com/postgresql/postgresql_select_query.htm

    Best Regards,
    Dillion

    Sunday, July 12, 2015 3:59 AM