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

From Tom Lane
Subject Re: Improving psql \ds
Date
Msg-id 1263.1349708399@sss.pgh.pa.us
Whole thread Raw
In response to Re: Improving psql \ds  (Julien Tachoires <julmon@gmail.com>)
Responses Re: Improving psql \ds
List pgsql-hackers
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.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Amit kapila
Date:
Subject: Re: Re: [WIP] Performance Improvement by reducing WAL for Update Operation
Next
From: Julien Tachoires
Date:
Subject: Re: Improving psql \ds