Re: Refine Form of My querry - Mailing list pgsql-general

From David Salisbury
Subject Re: Refine Form of My querry
Date
Msg-id 4EFC9676.5070906@globe.gov
Whole thread Raw
In response to Refine Form of My querry  (saqib11@igis.nust.edu.pk)
List pgsql-general

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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: PostgreSQL 9.1 pg_dump setval() sets wrong value
Next
From: Greg Donald
Date:
Subject: Re: PostgreSQL 9.1 pg_dump setval() sets wrong value