psql - list objects in a schema

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: psql - list objects in a schema
Date: 2004-06-30 18:09:32
Message-ID: Pine.LNX.4.44.0406302002130.21809-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

There is no command in psql to list the objects in a schema. The methods
I've had so far is

\d the_schema.*

that shows all objects in detail, not a list. And this is what I've been
doing:

\d the_schema.<tab><tab>

which shows a list of the names (if you have compiled psql with readline
and tab completion works).

So I decided to add a command to list the objects. When I looked in the
source I noticed that it already exists:

\dtvs the_schema.*

I bet most of you didn't know that!

This is like running \dt, \dv and \ds. This lists the tables, views and
sequences, which is mostly what we want (I want to see functions as well,
but you cant get everything).

--
/Dennis Björklund

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2004-06-30 19:01:31 Re: backups
Previous Message Markus Wollny 2004-06-30 18:05:17 Backward compatibility patch for numutils.c