From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Ryan Dobbs" <rdobbs(at)gmail(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Query tool not working |
Date: | 2006-03-03 08:14:06 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C91AD@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
________________________________
From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Ryan Dobbs
Sent: 03 March 2006 03:20
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Query tool not working
Hi,
I am new to postgeSQL and have recently installed version 8.1 on
my local machine.
I am running Windows XP Pro and am using pgAdmin III version
1.4.1
I created a database with all the required tables and columns.
I have also created all the primary keys and foreign keys and can view/
created columns and tables and sequences. At the moment there is no
data within the tables.
The problem is, when I use the query tool to do a select all
statement, It comes back with an error message saying the the table
could not be found. I have tried it on most of the tables, but get the
same error message. I am spelling the name of the table correctly.
Any ideas on how to fix this? Would it have something to do
with permissions?
Unlikely - it would say so if that were the case.
I suspect you have either used upper case characters in your table name,
and then not quoted it in your query - eg.
SELECT * FROM "FoO"
or, created the table in a schema not in the current search path, and
not qualified the name, such as:
SELECT * FROM myschema.foo
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2006-03-03 15:12:28 | Re: Difficulties Connecting on localhost |
Previous Message | Ryan Dobbs | 2006-03-03 03:20:06 | Query tool not working |