pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hélder M. Vieira <hmv@mail.telepac.pt>
To: pgsql-sql@postgresql.org
Subject: Re: table listing queries
Date: Thu, 25 Aug 2005 13:16:47 +0100
Message-ID: <005301c5a96e$df651e90$580bfea9@hmv02> (raw)
References: <1124968435.18119.1.camel@petitemort.i.digital-scurf.org>

> Namely, in MySQL I can say: "SHOW TABLES FROM 'dbname'" to list tables
> in a database I'm not currently connected to.

In MySQL, table definitions are replicated outside the database files, and 
might therefore be available without connecting to a specifc database.
This probably happens because of the need for some kind of unified 
repository of objects pertaining to different database engines.


Helder M. Vieira








view thread (3+ messages)

Message-ID: <005301c5a96e$df651e90$580bfea9@hmv02>
Permalink:  ../005301c5a96e$df651e90$580bfea9@hmv02/
Also on:    postgresql.org/message-id/005301c5a96e$df651e90$580bfea9@hmv02

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: hmv@mail.telepac.pt
  Subject: Re: table listing queries
  In-Reply-To: <005301c5a96e$df651e90$580bfea9@hmv02>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox