<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">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>Tue, 2/14/12, Bistrais, Bob <i><Bob.Bistrais@maine.gov></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><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<br><br><div id="yiv361148404">
<style>
<!--
#yiv361148404
#yiv361148404 p.yiv361148404MsoNormal, #yiv361148404 li.yiv361148404MsoNormal, #yiv361148404 div.yiv361148404MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
#yiv361148404 a:link, #yiv361148404 span.yiv361148404MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv361148404 a:visited, #yiv361148404 span.yiv361148404MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv361148404 span.yiv361148404EmailStyle17
{font-family:Arial;color:windowtext;}
_filtered #yiv361148404 {margin:1.0in 1.25in 1.0in 1.25in;}
#yiv361148404 div.yiv361148404Section1
{}
-->
</style>
<div>
<div class="yiv361148404Section1">
<p class="yiv361148404MsoNormal"><font face="Arial" size="2"><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></p>
</div>
</div>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net" href="/mc/compose?to=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></div></blockquote></td></tr></table>