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

Re: Table recognition

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Rodriguez <pfrodri(at)attglobal(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Table recognition
Date: 2001-01-17 17:15:01
Message-ID: 17645.979751701@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Peter Rodriguez <pfrodri(at)attglobal(dot)net> writes:
> I have PostgreSQL installed on my stand-alone machine with RedHat 6.2. I
> have created several tables in one database using Pgaccess and have no
> problems using them through the GUI. However, when I try to use the psql
> interface, although it successfully lists the tables, when I try to
> operate on them, I get the error message  "..table does not exist".
> Maybe I am missing something - any suggestions, please?

Are you using mixed-case table names?  I think pgaccess will double
quote all names for you ... but psql won't, which means your table
names had better be lower case if you don't want to type quotes all
the time.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Laurel WilliamsDate: 2001-01-17 17:29:28
Subject: Postgres superuser & password on Red Hat; upgrade?
Previous:From: Tom LaneDate: 2001-01-17 16:16:20
Subject: Re: LIKE optimization

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