search

NYCPlanning / labs-postgis-preview

A lightweight express app and leaflet frontend for previewing PostGIS queries
MIT License
277 stars 57 forks source link

Relation to Table does not exist #55

Closed imFarrukh closed 6 years ago

imFarrukh commented 6 years ago

I am typing my query in query tab as Select * from Fuel (My Table/layer present in the postgis Database) But em getting message realtion "Fuel" Does not exist. Same result for other tables. When i am using this query in pgadmin there is no issue. Can anyone guide me what to do. Any suggestion image

rajanski commented 6 years ago

If the table in question is not in schema public, maybe try to set search_path to include the other schema too or alternatively query the table as in " select * from "my_other_schema"."Fuel" . Or check uppercase / lowercase issues with the table name

imFarrukh commented 6 years ago

image My table is in "Schemas-Public"

imFarrukh commented 6 years ago

Thank you Rajanski ,,,,i fixed my issue just placing " " this :) Thanks u once again :)

chriswhong commented 6 years ago

Closing as this seems to have been resolved

erickndava commented 5 years ago

I am having this issue. Have tried the "area_bounds"."wards" (in my case) still getting relation does not exist. Any pointers?

chriswhong commented 5 years ago

Can you post a screenshot of the working query in another tool like pgAdmin? Just want to make sure the table names are correct.

imFarrukh commented 5 years ago

Can you post a screenshot of the working query in another tool like pgAdmin? Just want to make sure the table names are correct.

Chris Thank you ......,i fixed my issue just placing " " this :) Thanks u once again :)

erickndava commented 5 years ago

Can you post a screenshot of the working query in another tool like pgAdmin? Just want to make sure the table names are correct.

Query in DBeaver

dbeaver

Same query in Postgis-Preview.

postgis-preview

chriswhong commented 5 years ago

Assume you have tried just saying public.wards without the quotes?

erickndava commented 5 years ago

Yes. That was the first shot. The quotes came after reading the thread and attempting to 'make it work'. On Wed, 03 Apr 2019, 16:43 Chris Whong, notifications@github.com wrote:

Assume you have tried just saying public.wards without the quotes?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/NYCPlanning/labs-postgis-preview/issues/55#issuecomment-479520007, or mute the thread https://github.com/notifications/unsubscribe-auth/AFOurF3kMVHzuougwZ1GmsKOSsQohbq1ks5vdL35gaJpZM4QXsr_ .

erickndava commented 5 years ago

Here's the data (csv) exported from the public schema.

wards_201904032252.zip