<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Times New Roman'; COLOR: #00002b; FONT-SIZE: 12pt">
<DIV>The case was the problem. </DIV>
<DIV> </DIV>
<DIV>Thanks Mark</DIV>
<DIV> </DIV>
<DIV>Bob</DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV style="FONT: 10pt tahoma">
<DIV> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=mark.wimer@gmail.com
href="mailto:mark.wimer@gmail.com">MarkW</A> </DIV>
<DIV><B>Sent:</B> Wednesday, May 18, 2011 12:05 PM</DIV>
<DIV><B>To:</B> <A title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users Discussion</A>
</DIV>
<DIV><B>Subject:</B> Re: [postgis-users] Invisible Table</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">Do
you mean that the SQL Pane shows this: <BR>CREATE TABLE
public."MyTestTable"<BR>( etc... )<BR><BR>Case-sensitivity may be the
issue - does your simple sql query include quotes around the table
name?<BR><BR>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 <BR>change table and column names to lowercase for you.
<BR><BR>Mark<BR><BR>
<DIV class=gmail_quote>On Wed, May 18, 2011 at 2:39 PM, Bob Pawley <SPAN
dir=ltr><<A href="mailto:rjpawley@shaw.ca">rjpawley@shaw.ca</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV dir=ltr>
<DIV dir=ltr>
<DIV
style="FONT-FAMILY: 'Times New Roman'; COLOR: rgb(0,0,43); FONT-SIZE: 12pt">
<DIV>Hi</DIV>
<DIV> </DIV>
<DIV>I imported a shape file using the QGis shapefile to PostgreSQL
tool.</DIV>
<DIV> </DIV>
<DIV>The resulting table appears as normal on the PGAdmin Object Browser and
in QGis as spatial geometry.</DIV>
<DIV> </DIV>
<DIV>However the table is not existing according to a simple sql query. Other
tables are seen with no problem.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>The other tables, self created not imported, do not have the quotes
around the table name.</DIV>
<DIV> </DIV>
<DIV>Would these quotes be the cause of an sql query not being able to see the
table??</DIV>
<DIV> </DIV><FONT color=#888888>
<DIV>Bob</DIV></FONT></DIV></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR>
<P>
<HR>
_______________________________________________<BR>postgis-users mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></DIV></DIV></DIV></BODY></HTML>