<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
_filtered #yiv361148404 {margin:1.0in 1.25in 1.0in 1.25in;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p.yiv361148404msonormal, li.yiv361148404msonormal, div.yiv361148404msonormal
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
p.yiv361148404msonormal1, li.yiv361148404msonormal1, div.yiv361148404msonormal1
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.yiv361148404msohyperlink1
{color:blue;
text-decoration:underline;}
span.yiv361148404msohyperlinkfollowed1
{color:purple;
text-decoration:underline;}
span.yiv361148404emailstyle171
{font-family:Arial;
color:windowtext;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi Brent,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>One quick observation- I need to quote the
table name with the \d mytable and select statements, in order to get any
output, otherwise it says “did not find relation name Metwp100Poly”. Does that
sound right? <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>pcreso@pcreso.com<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, February 13, 2012
5:06 PM<br>
<b><span style='font-weight:bold'>To:</span></b> PostGIS Users Discussion<br>
<b><span style='font-weight:bold'>Cc:</span></b> Bistrais, Bob<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [postgis-users]
Trouble seeinglisting tables</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Nothing obvious that I can see.<br>
<br>
<br>
psql -d <db><br>
<br>
\d
# should list the tables<br>
\d mytable # should list the structure of the table
"mytable"<br>
select * from mytable; # should list the contents of mytable.<br>
<br>
<br>
If you can post the outputs from these commands (the text before the
"#") we can probably offer more informed advice.<br>
<br>
Cheers<br>
<br>
Brent Wood<br>
<br>
<br>
<br>
--- On <b><span style='font-weight:bold'>Tue, 2/14/12, Bistrais, Bob <i><span
style='font-style:italic'><Bob.Bistrais@maine.gov></span></i></span></b>
wrote:<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
From: Bistrais, Bob <Bob.Bistrais@maine.gov><br>
Subject: [postgis-users] Trouble seeinglisting tables<br>
To: "PostGIS Users Discussion"
<postgis-users@postgis.refractions.net><br>
Date: Tuesday, February 14, 2012, 9:58 AM<o:p></o:p></span></font></p>
<div id=yiv361148404>
<div>
<div>
<p class=yiv361148404msonormal><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>I am having trouble on a pretty
basic level. I loaded a couple shapefiles into PostGIS. I can see
that they successfully loaded when I use pgAdmin. But when I go to
command line, I have trouble. I can do a \d command and see the tables
exist in the database. But if I do a select * from mytable; I get an
errer, “relation “mytable” does not exist. What am I doing wrong here?</span></font><o:p></o:p></p>
</div>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
-----Inline Attachment Follows-----<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>_______________________________________________<br>
postgis-users mailing list<br>
<a href="/mc/compose?to=postgis-users@postgis.refractions.net"
ymailto="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><o:p></o:p></span></font></p>
</div>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>