Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables

<blockquote style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px;
PADDING-RIGHT:0px"><p><font face="Arial" size="2"><font face="Courier" size="2">jobshop=> </font></font><p><font
face="Courier"size="2">jobshop=> select relname, usename, relhasrules from pg_class, pg_user where relk<br />ind =
'r'and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)<br />order by relname;<br
/>relname|usename|relhasrules<br/>-------+-------+-----------<br />(0 rows)</font><p><font face="Courier"
size="2">jobshop=></font><p><fontface="Courier" size="2">jobshop=> \d<br />Couldn't find any tables, sequences or
indices!<br/>jobshop=></font><p><font face="Courier" size="2">jobshop=> \d joblistings   <- The name of one of
mytables.</font><p><font face="Courier" size="2">Table    = joblistings<br
/>+----------------------------------+----------------------------------+-------+<br/>|             
Field              |              Type                | Length|<br
/>+----------------------------------+----------------------------------+-------+<br/>|
listingid                       | int4 not null default nextval('j |     4 |<br />| officeid                         |
int4                            |     4 |<br />| posteddate                       | date                            
|    4 |<br />| enabled                          | bool                             |     1 |<br />|
description                     | text                             |   var |<br />| numpositions                     |
int2                            |     2 |<br />| locationdescription              | text                            
|  var |<br />| extrahtml                        | text                             |   var |<br
/>+----------------------------------+----------------------------------+-------+<br/>Index:   
joblistings_listingid_key</font><p><fontface="Arial" size="2"><font face="Courier" size="2">jobshop=>
</font></font><p> <p>  <p>Don't do a select * from pg_class.... Do the exact entire query that you see in the logfile 
(selectrelname, usename .... where relkind ....) and see what you get. <p>Also, if you do a "\d" in the monitor, what
doyou get? <p>Byron </blockquote>