Skip site navigation (1) Skip section navigation (2)

Re: Refine Form of My querry

From: David Salisbury <salisbury(at)globe(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Refine Form of My querry
Date: 2011-12-29 16:33:58
Message-ID: 4EFC9676.5070906@globe.gov (view raw or flat)
Thread:
Lists: pgsql-general

On 12/29/11 3:11 AM, saqib11(at)igis(dot)nust(dot)edu(dot)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

In response to

pgsql-general by date

Next:From: Greg DonaldDate: 2011-12-29 16:53:47
Subject: Re: PostgreSQL 9.1 pg_dump setval() sets wrong value
Previous:From: Merlin MoncureDate: 2011-12-29 16:27:47
Subject: Re: PostgreSQL 9.1 pg_dump setval() sets wrong value

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group