Re: Refine Form of My querry

On 12/29/11 3:11 AM, saqib11@igis.nust.edu.pk wrote:
> Hi every1 how are u all??? Members i am new in postgres and want to
> work on pgrouting but i am facing some issue with it. Will u please help
> me???
> I have loaded my line shapefile in pgadmin environment, which creates a
> table name 'Route', but when i made a query 'Create View' at it, it will
> show an error that "Relation 'Route' doesn't exist". can any1 explains
> me what this error means?? and how can i remove this error??

I'm guessing you need double quotes around your table name.. e.g. "Routes"..
in your view definition as the table name may be case sensitive, in your case.

-ds