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