Skip site navigation (1) Skip section navigation (2)

Re: small psql patch - show Schema name for \dt \dv \dS

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: small psql patch - show Schema name for \dt \dv \dS
Date: 2002-07-20 14:51:35
Message-ID: 3D3978F7.90601@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-patches
Tom Lane wrote:
> Joe Conway <mail(at)joeconway(dot)com> writes:
> 
>>It sorts on "Schema" first, and "Name" second.
> 
> 
>>Sample output:
>>                  List of relations
>>         Name        |   Schema   | Type |  Owner
>>--------------------+------------+------+----------
>>  __testpassbyval    | public     | view | postgres
>>  fooview            | public     | view | postgres
>>  master_pg_proc     | public     | view | postgres
>>  rmt_pg_proc        | public     | view | postgres
>>  vw_dblink_get_pkey | public     | view | postgres
>>  vw_dblink_replace  | public     | view | postgres
>>  ts_view            | testschema | view | postgres
> 
> 
> It seems rather odd and confusing that the sort order takes the second
> column as the major key.  I think that the sort ordering should be
> column 1 then 2.  That means either putting the schema column first,
> or keeping this column ordering and sorting on relname before schema.
> I lean towards the first choice but can see a case for the second.
> 
> 			regards, tom lane

OK -- I see your point on the second option, but I also lean towards the 
first. I'll change it to schema column first, order by column 1 then 2.

Joe



In response to

pgsql-patches by date

Next:From: Joe ConwayDate: 2002-07-20 14:52:50
Subject: Re: show() function - updated patch
Previous:From: Tom LaneDate: 2002-07-20 14:27:48
Subject: Re: show() function - updated patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group