Re: relation problem - Mailing list pgsql-novice

From Jeff Daugherty
Subject Re: relation problem
Date
Msg-id 3AAFB99D.30901@greatbridge.com
Whole thread Raw
In response to relation problem  ("Dax Duskin" <dax.duskin@zsassociates.com>)
List 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
>
>


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [GENERAL] Re: compilation error
Next
From: "G. Anthony Reina"
Date:
Subject: SELECT query