Re: List schema contents

Neil Conway <neilc@samurai.com>

From: Neil Conway <neilc@samurai.com>
To: "Jim C. Nasby" <jnasby@pervasive.com>
Cc: pgsql-hackers@postgresql.org
Date: 2006-06-09T19:52:52Z
Lists: pgsql-hackers
On Fri, 2006-06-09 at 14:33 -0500, Jim C. Nasby wrote:
> Currently, the only way to get a listing of tables in a schema via psql
> is to modify your search_path, which is both non-intuitive and a PITA.

I've griped about psql's limited support for schemas in the past:

http://archives.postgresql.org/pgsql-hackers/2004-10/msg00989.php
http://archives.postgresql.org/pgsql-hackers/2004-11/msg00014.php

I never actually got around to making any behavioral changes, but I
agree there is certainly room for improvement.

(The fact that archives.p.o can't properly link between threads that
cross month boundaries is pretty annoying...)

-Neil