Thread

not tables found on PostgreSQL 6.5

sascha.kettler@team17.com — 1999-07-13T10:45:40Z

Your name: Sascha Kettler
Your email address: skettler@team17.com

System Configuration
---------------------
Architecture (example: Intel Pentium)         : 
Intel Pentium III-450

Operating System (example: Linux 2.0.26 ELF)  : 
Linux 2.2.10 ELF

PostgreSQL version (example: PostgreSQL-6.5)  : 
PostgreSQL-6.5

Compiler used (example:  gcc 2.8.0)           :
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)


Please enter a FULL description of your problem:
------------------------------------------------
psql and pg_dump[all] don't find any tables


Please describe a way to repeat the problem.   Please try to 
provide aconcise reproducible example, if at all possible: 
----------------------------------------------------------------------
$ createdb test
$ psql test
test=> create table test (
test-> sid varchar(32),
test-> name varchar(32));
CREATE
test=> \q
$ psql test
test=> select * from test;
sid|name
---+----
(0 rows)

test=> \d
Couldn't find any tables, sequences or indices!
test=> \d test

Table    = test
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| sid                              | varchar()                        |    32 |
| name                             | varchar()                        |    32 |
+----------------------------------+----------------------------------+-------+
test=> \q




If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------