User Profile

Collapse

Profile Sidebar

Collapse
monkeyxu
monkeyxu
Last Activity: Jan 22 '08, 09:06 PM
Joined: Oct 11 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • monkeyxu
    started a topic postgreSQL user permission denied
    in PostgreSQL

    postgreSQL user permission denied

    Hi, all

    I am new for psql and here is my problem.
    I created a new psql user with no superuser no role creation and no DB creation. So when the new user tries to query a table and got:

    postgis_test_db => SELECT vessel_name, time, position FROM current_positio n;
    postgis_test_db => ERROR: permission denied for relation current_positio n

    Any suggestions will be greatly appreciated
    ...
    See more | Go to post
    • monkeyxu
      started a topic converting POINT(-43.16 -0.876) to Latitude and Longitude
      in PostgreSQL

      converting POINT(-43.16 -0.876) to Latitude and Longitude

      Hi, Postgresql/PostGIS Guru

      I am new for both Postgresql/PostGIS and need help for converting point () to latitude and longitude degrees using some kind of PostGIS functions. I have a ship's point position in my postsql table as:

      ship-name POINT(-43.18375956 -0.87618425) and want to get the position in degrees. An example will be greatly appreciated.

      Thanks

      Monkey
      See more | Go to post
      No activity results to display
      Show More
      Working...