Try putting quotes around the table name:
select * from "Table";
?
Do you see it in the table list?
\dt
Tommy Svensson wrote:
I have just installed Postgresql and tried it for the first time.
One very serious problem I ran into was when actually trying to use created tables.
Creating a simple table without any foreign keys works OK, but after creating the
table it is not possible to do a select on it! I tried the following variants:
SELECT * FROM <table>; SELECT * FROM public.<table>; SELECT * FROM <schema>.public.<table>;
All result in the message "The relation <table> does not exist!" or "The relation public.<table> does not exist!".
Creating a new table with a foreign key referencing the first table is also impossible due to exactly the same error message!
This behaviour is the same using DBVisualizer/jdbc or psql.
So the question is how do you actually reference the tables you have created so that postgres will find them ?
The tables do actually get created. I can se them in DBVisualizer.
I'm using version 7.4.5 on Linux Mandrake 10.1.
Best Regards, Tommy Svensson
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
-- Regards,
Chris Smith
Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia
Ph: +61 2 9517 2505 Fx: +61 2 9517 1915
email: info@xxxxxxxxxxxxxx web: www.interspire.com
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
