MySQL-ism help patch for psql
in [PgSql]
|
Prev: Helping the CommitFest re PL/Perl changes
Next: [HACKERS] MonetDB test says that PostgreSQL often has errors or missing results
From: Dimitri Fontaine on 19 Jan 2010 17:37 Robert Haas <robertmhaas(a)gmail.com> writes: > Although the deadline for patches for 8.5 has supposedly already passed..... I guess it already got more review than some of the commit fest items already⦠Regards, -- dim -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Craig Ringer on 19 Jan 2010 20:54 On 20/01/2010 6:31 AM, Rob Wultsch wrote: > As a MySQL DBA the commands I think are most useful are: > show databases (please punt this, most MySQL dba's that I have worked > with will need to consider the difference between a db and a schema) > use database (please punt) So perhaps for SHOW DATABASES the help should suggest: " \l - list databases; or \dn - list schema " ? -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: "Greg Sabino Mullane" on 19 Jan 2010 21:56 -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > 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. +1 >> What if some other people will come up with the idea of adding similar >> functionality for their favorite database? The only exception will be >> Informix IMHO, because of historical reasons. > I think it'd be helpful for other databases, too. Oracle comes to mind: > What commands are finger-trained in Oracle DBAs? Ha! Best laugh I've had all week. The finger training consists of "double click the mouse, navigate the GUI to find your table...". For command line, you have monstrosities such as "select * from ALL_ALL_TABLES" and "select * from TABS" - unless they've implemented some sort of shortcuts since the last time I used Oracle. Which seems very unlikely, as they obviously have no love for sqlplus (Oracle's command line client), which has been stuck technologically in place for decades (hello, readline?) - -- Greg Sabino Mullane greg(a)turnstep.com PGP Key: 0x14964AC8 201001192155 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAktWcMkACgkQvJuQZxSWSsgAoQCgw/9e+viAs6RyGCeuSze42oqx Ym4An2Q9FSpXYkX1ZC507Y/NwUb3ODmG =fnUL -----END PGP SIGNATURE----- -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Greg Stark on 20 Jan 2010 04:19 this is mostly true. I don't think any Oracle DBA will expect ALL_TABLES our DBA_TABLES to be there. however DESCRIBE and HELP would be the two that come to mind. greg On 20 Jan 2010 02:56, "Greg Sabino Mullane" <greg(a)turnstep.com> wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > Why would they want more? It's not MySQL, and they know that. > If we give them some very minor ... +1 >> What if some other people will come up with the idea of adding similar >> functionality for thei... Ha! Best laugh I've had all week. The finger training consists of "double click the mouse, navigate the GUI to find your table...". For command line, you have monstrosities such as "select * from ALL_ALL_TABLES" and "select * from TABS" - unless they've implemented some sort of shortcuts since the last time I used Oracle. Which seems very unlikely, as they obviously have no love for sqlplus (Oracle's command line client), which has been stuck technologically in place for decades (hello, readline?) - -- Greg Sabino Mullane greg(a)turnstep.com PGP Key: 0x14964AC8 201001192155 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAktWcMkACgkQvJuQZxSWSsgAoQCgw/9e+viAs6RyGCeuSze42oqx Ym4An2Q9FSpXYkX1ZC507Y/NwUb3ODmG =fnUL -----END PGP SIGNATURE----- -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your su...
From: Peter Eisentraut on 20 Jan 2010 08:15
On tis, 2010-01-19 at 11:43 -0800, Jeff Davis wrote: > I'll make an analogy to: > > $ git difff > git: 'difff' is not a git-command. See 'git --help'. > > Did you mean this? > diff This is presumably spelling-based, which might be an interesting feature (although probably useless for psql's single-letter commands). Maybe this analogy is more interesting, for a user that recently used cvs: $ git update git: 'update' is not a git-command. See 'git --help'. Did you mean this? update-ref --> Probably not. -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |