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
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 |