Re: Patch rev 2: MySQL-ism help patch for psql

On Jan 19, 2010, at 6:01 PM, David Christensen wrote:

>
> On Jan 19, 2010, at 4:23 PM, Robert Haas wrote:
>
>> On Tue, Jan 19, 2010 at 5:14 PM, David E. Wheeler <david@kineticode.com 
>> > wrote:
>>> Why would they want more? It's not MySQL, and they know that. If  
>>> we give them some very minor helpful hints for the most common  
>>> things they try to do, it would be a huge benefit to them. I know  
>>> I've badly wanted the opposite when I've had to use MySQL, but I  
>>> don't expect MySQL to implement \c for me.
>>
>> +1.  I think this is a well-thought out proposal.  I like Tom's
>> suggestion upthread for how to handle \c.
>
> I've attached a second revision of this patch incorporating the  
> various feedback I've received.
>
>> Although the deadline for patches for 8.5 has supposedly already  
>> passed....
>
> Yeah, I realized this after I scratched my itch, and had just  
> thought I would send to the list any way for after the CF; you can  
> commit or bump as needed.  Patch enclosed as a context-diff  
> attachment this time.


I also forgot to enclose the sample output in this version, based  
largely on Tom's wording for the USE usecase:

----
machack:machack:5432=# show tables

Perhaps you want "\dt"?
See \? for help with psql commands

[Tue Jan 19 18:04:50 CST 2010]
machack:machack:5432=# use database;

Perhaps you want "\c database" or "set search_path = schema"?
See \? for help with psql commands

[Tue Jan 19 18:05:07 CST 2010]
machack:machack:5432=#
----

Regards,

David
--
David Christensen
End Point Corporation
david@endpoint.com