Re: table listing queries

From: Hélder M(dot) Vieira <hmv(at)mail(dot)telepac(dot)pt>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: table listing queries
Date: 2005-08-25 12:16:47
Message-ID: 005301c5a96e$df651e90$580bfea9@hmv02
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Lars Haugseth 2005-08-25 12:21:20 Re: How this query!
Previous Message Richard Susanto 2005-08-25 11:44:00 How this query!