Re: Listing schemas

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Francisco Reyes <lists(at)natserv(dot)com>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Listing schemas
Date: 2003-03-02 00:31:41
Message-ID: 20030302003141.GB16937@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 28, 2003 at 18:14:56 -0500,
Francisco Reyes <lists(at)natserv(dot)com> wrote:
> I don't see a way to list schemas in a database other than
> select distinct schemaname from pg_tables;
>
> Did I miss something? I was expecting to find something along the lines of
> the \d functions in pgsql.

There is a way to do this in 7.4. For 7.3 you need to use a select.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Detlef Jockheck 2003-03-02 12:49:57 Doing multiple steps at once
Previous Message Mark Cave-Ayland 2003-03-01 21:09:37 plpgsql memory leak in 7.3.2?