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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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