[postgis-users] Invisible Table

[Bob Pawley]

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 <rjpawley at 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 at postgis.refractions.net
  http://postgis.refractions.net/mailman/listinfo/postgis-users






--------------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110518/cb483999/attachment.html>