The case was the problem. Thanks Mark
Bob From: MarkW Sent: Wednesday, May 18, 2011 12:05 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Invisible Table Do you mean that the SQL Pane shows this: CREATE TABLE public."MyTestTable" ( etc... ) Case-sensitivity may be the issue - does your simple sql query include quotes around the table name? If it is a case-sensitivity issue and you want to avoid it, the Shapefile and Dbf gui loader plugin for PGAdmin (as one example of another way to do it) will change table and column names to lowercase for you. Mark On Wed, May 18, 2011 at 2:39 PM, Bob Pawley <rjpaw...@shaw.ca> wrote: Hi I imported a shape file using the QGis shapefile to PostgreSQL tool. The resulting table appears as normal on the PGAdmin Object Browser and in QGis as spatial geometry. However the table is not existing according to a simple sql query. Other tables are seen with no problem. The only difference I can detect is when the table name in the Object Browser is highlighted the SQL Pane shows quotes around the table name in the Create Table statement. The other tables, self created not imported, do not have the quotes around the table name. Would these quotes be the cause of an sql query not being able to see the table?? Bob _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -------------------------------------------------------------------------------- _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
