Re: psql and schemas
От | Neil Conway |
---|---|
Тема | Re: psql and schemas |
Дата | |
Msg-id | 1099456069.9284.95.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: psql and schemas (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Tue, 2004-11-02 at 01:44, Tom Lane wrote: > Neil Conway <neilc@samurai.com> writes: > > I think there needs to be a way to list all the objects in a schema. > > This doesn't seem especially helpful to me, because you'd have to fit a > bunch of different object types into a one-size-fits-all output, which > would end up fitting nothing very well. The same comment applies to "\d", but I think that is still a useful command. Note that we wouldn't need to list _everything_ in a schema for this to be useful, in the same way that "\d" doesn't list everything in the search path. > It's not clear to me that we need do more, especially since the user > probably knows what kinds of objects he's created Among other things, psql is a tool for exploring the content of a database; assuming that the user already knows what is in the database doesn't strike me as wise. I can think of plenty of scenarios in which someone using psql would like to get a quick summary of the content of a schema they know nothing about. But in any case I'll leave this for later. -Neil
В списке pgsql-hackers по дате отправления: