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

\dt is listing tables from all databases

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: \dt is listing tables from all databases
Date: 2010-01-14 19:49:01
Message-ID: 7c1574a91001141149o69e130cfx8aa32992580e9111@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Greetings,
I've got a postgresql server running 8.1.10 on Linux.  I've noticed
that when i'm logged into one of the databases, and I run '\dt' its
listing every table from every database on the server (rather than
just the tables in the current database instance).  To make matters
even more strange, if I log into any of the other databases and run
'\dt' it only lists the tables in that database (as expected).  I'm
connecting as the same user every time.

Any ideas why this is happening?

thanks

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-01-14 20:58:10
Subject: Re: \dt is listing tables from all databases
Previous:From: Daniel StaalDate: 2010-01-13 18:11:03
Subject: Re: select for update question

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