[postgis-users] Invisible Table

[MarkW]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110518/f89bb4f0/attachment.html>