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

Re: relation problem

From: Jeff Daugherty <jdaugherty(at)greatbridge(dot)com>
To: Dax Duskin <dax(dot)duskin(at)zsassociates(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: relation problem
Date: 2001-03-14 18:34:05
Message-ID: 3AAFB99D.30901@greatbridge.com (view raw or flat)
Thread:
Lists: pgsql-novice
Something to check:
   Case sensitivity.   If you create a table in pgaccess with a capital 
letter in it, when querying the table in psql you will need to put the 
table name in quotes "".
SELECT * FROM "Table";

Jeff Daugherty
Database Systems Engineer
Great Bridge, LLC

Dax Duskin wrote:

> Hi everybody:
> 
> I created a table using pgaccess and put some sample data in it.  When I went to
> run a query on it psql I found that there was no relation.  "Relation does not
> exist."  It looks like I completely lost my table.  I'm just glad it wasn't real
> data.  I also tried running a perl script with a query to the table and it
> returned an error.
> 
> Any ideas as to what is going on?
> 
> Thanks,
> Dax Duskin
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 
> 


In response to

pgsql-novice by date

Next:From: G. Anthony ReinaDate: 2001-03-14 19:13:53
Subject: SELECT query
Previous:From: Tom LaneDate: 2001-03-14 18:18:35
Subject: Re: [NOVICE] Re: Re: compilation error <segunda parte>

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