On Sun, Feb 27, 2005 at 06:50:50PM -0500, Tommy Svensson wrote: > 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!". Could you copy and paste the *exact* commands and error messages and send them to the list? That might help us see what's going on. > The tables do actually get created. I can se them in DBVisualizer. If you run psql, what does \d show? (Again, please copy and paste the exact output.) Is it possible that you created the tables in mixed case and didn't quote their names when you tried to query them? If so, then you might want to read "Identifiers and Key Words" in the "SQL Syntax" chapter of the documentation. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
