Skip site navigation (1) Skip section navigation (2)

Can't list tables

From: Jan Chrillesen <jan(at)chrillesen(dot)dk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Can't list tables
Date: 2001-05-13 11:21:25
Message-ID: 20010513132125.A24344@vax.chrillesen.dk (view raw or flat)
Thread:
Lists: pgsql-novice
I'm running 7.0.3 and want to upgrade to 7.1.1, but running pg_dumpall
only dumps template1. Also psql -l only lists template1 - the same with
\l

pg_dump <dbname> dumps nothing, but I'm still able to connect to a
database with psql and perform queries on the database. When connected
to a database \dt returns an empty list, so I guess I manage to break
something. Is it in any way possible to dump the existing databases and
upgrade to 7.1.1?

/Jan

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2001-05-13 15:33:55
Subject: Re: Can't list tables
Previous:From: peteDate: 2001-05-11 22:11:01
Subject: Re: Looking for good reference materials for SQL programming.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group