Re: Improving psql \ds - Mailing list pgsql-hackers

From Julien Tachoires
Subject Re: Improving psql \ds
Date
Msg-id CAFEQCbFPxa=ZhztjYLZwKd-v3HkBgfdT3XqrTURjs=J1OGw1-g@mail.gmail.com
Whole thread Raw
In response to Re: Improving psql \ds  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2012/10/8 Tom Lane <tgl@sss.pgh.pa.us>:
> Julien Tachoires <julmon@gmail.com> writes:
>> 2012/10/8 Tom Lane <tgl@sss.pgh.pa.us>:
>>> The other problem you're going to have here is that there is in fact no
>>> such command as "\ds" (nor "\ds+"); rather, it's a special case of
>>> \dtsvi.  As such, putting any relkind-specific info into the result is
>>> problematic.  I think you're going to have to invent a different command
>>> if you want there to be sequence-specific columns.
>
>> Yes, that's why I plan to create a new function listSequences() and
>> call it from src/bin/psql/command.c :
>> +             /* \d* commands */
>> +     else if (cmd[0] == 'd')
>> +     {
>> ...
>> +                     case 's':
>> +                             success = listSequences(pattern, show_verbose);
>> +                             break;
>
> No, that's not acceptable, because it will break cases such as "\dstv".
>
> The \dxxx command namespace is already direly overloaded; I'm not sure
> cramming more behaviors into it is a good idea anyway.  Perhaps
> something along the line of "\seqs" would be a usable substitute.

Ok. Does having both '\ds' and , let's call it '\seqs', won't be
source of confusion for the user ?



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Add FET to Default and Europe.txt
Next
From: Bruce Momjian
Date:
Subject: Re: Add FET to Default and Europe.txt