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: Andrew Dunstan on 20 Jan 2010 10:00 Robert Haas wrote: > I'm actually no big advocate of the \d commands. They're basically > magical queries that you can't easily see or edit - I've more than > once wished for a WHERE clause (\df WHERE "Result data type" = > 'internal' or what have you. > You *can* easily see them, at least. Run "psql -E" or inside psql do "\set ECHO_HIDDEN" cheers andrew -- 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: Dimitri Fontaine on 20 Jan 2010 10:11 Robert Haas <robertmhaas(a)gmail.com> writes: > If what the user wanted was to be using MySQL, he is out of luck > anyway. That's not what we're talking about. We're talking about having a nice client tool for those people having to do both MySQL and PostgreSQL support, or new to PostgreSQL and comming from MySQL. I'll give my vote to Peter's idea that show tables; should better act as if you typed \d. I don't see what the gain is to refuse being nice to MySQL newcomers when someone actually does the work. If the USE keyword is one we want to keep free for our own usage, let just skip that compat option. > I'm actually no big advocate of the \d commands. They're basically > magical queries that you can't easily see or edit We already have the psql \set ECHO_HIDDEN command to easily see the query, then it's a copy/paste away. I'd propose to have this setting also make it so that the query it runs is placed in the buffer for next \e command, which is not the case in 8.4. 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: Bruce Momjian on 20 Jan 2010 10:19 Dimitri Fontaine wrote: > Robert Haas <robertmhaas(a)gmail.com> writes: > > If what the user wanted was to be using MySQL, he is out of luck > > anyway. > > That's not what we're talking about. We're talking about having a nice > client tool for those people having to do both MySQL and PostgreSQL > support, or new to PostgreSQL and comming from MySQL. > > I'll give my vote to Peter's idea that show tables; should better act as > if you typed \d. > > I don't see what the gain is to refuse being nice to MySQL newcomers > when someone actually does the work. If the USE keyword is one we want > to keep free for our own usage, let just skip that compat option. I think the problem is that many other MySQL commands will not work or be supported, and if you give the person the desired output _and_ a suggestion to use \d, the suggests is easily overlooked. -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- 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: "Kevin Grittner" on 20 Jan 2010 10:30 Dimitri Fontaine <dfontaine(a)hi-media.com> wrote: > I'll give my vote to Peter's idea that show tables; should better > act as if you typed \d. I guess we don't need a "tables" GUC. Show all wouldn't include it? Would we require a semicolon? Do we support \d-style globs? Still seems kinda messy. +1 for help to show the PostgreSQL command as a guess for what they want to do. -1 for MySQL emulation. -Kevin -- 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: Gabriele Bartolini on 20 Jan 2010 10:38
I would personally emulate \d and take the chance for showing a funny warning, something like: "hey, it's not MySql!" or similar. I am sure we will Finder something appropriate. :) Inviato da iPhone Il giorno 20/gen/2010, alle ore 16.30, "Kevin Grittner" <Kevin.Grittner(a)wicourts.gov > ha scritto: > Dimitri Fontaine <dfontaine(a)hi-media.com> wrote: > >> I'll give my vote to Peter's idea that show tables; should better >> act as if you typed \d. > > I guess we don't need a "tables" GUC. Show all wouldn't include it? > Would we require a semicolon? Do we support \d-style globs? > > Still seems kinda messy. +1 for help to show the PostgreSQL command > as a guess for what they want to do. -1 for MySQL emulation. > > -Kevin > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |