Re: [GENERAL] Is my MySQL Gaining ?

Quoting Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>:

> On Sunday 28 December 2003 11:15, D. Dante Lorenso wrote:
> > The only SQL customizations that MySQL has that I really miss in
> PostgreSQL
> > are the commands:
> >
> > SHOW DATABASES;
>
> \l
>
> > SHOW TABLES;
>
> \dt
>
> > DESC table;
>
> \d tablename
>
> >
> > That was ubber simple to do in MySQL. To this day, I have trouble with
> > that in PostgreSQL. I'm constantly doing:
> >
> > psql> \?
> > psql> help;
> > ERROR: syntax error at or near "help" at character 1
> > psql> \h
> > ...
> > * damnit, that's not it...*
> > psql> \?
> > psql> \d
> > * ok, now which flag do I use for tables vs functions..etc?*
>
> \df for functions and \dt for tables.
>
> Problem is psql is unique though very powerful. I need to use oracle's
> sql-plus on HP-UX at times(Otherwise I crawl back to TOAD) and I don't think
>
> it is nowhere near to psql.
>
> or may be I play with postgresql more than oracle..:-) anyways
>
> > I finally figure it out, I just end up forgetting again later. I still
> > have no clue how I'd find the same data without using psql. In MySQL
> > I can run those queries from PHP, PERL...etc. I know you can find that
> > data in system tables in PostgreSQL, but I don't wanna muck around with
> > all that. I just wanna do something as simple as MySQL.
>
> Well, actually I would say it is great way of learning postgresql internals.
>
> There is a switch -E to psql which shows you queries sent to server for each
>
> command you provide.
>
> Problem with mysql is the approach is easy to start with but adding those
> command in your standard list of SQL commands falls out on standard
> compliance and maintainability.
>
> Another post on this thread mentioned postgresql should run against oracle.
> Sole reason postgresql v/s mysql debate should exist is to provide
> comparision in feasibility study. The hurdles you mentioned are true but that
>
> are just part of bit steeper learning curve of a standard way of doing
> things..
>
> Shridhar

This is what I don't get. Why do people thing learn PG is going to be like
learning MySQL in the first place? Because its OSS?? I certainly hope not.
This is apples to oranges.

I read someone say the documentation was "light" too. I'm not sure what that
meant but I looked for at the 3 inch doubled side binded of my 7.3.2 docs-
admin,user &,programmer- its as big as my J2EE binder.

Not very scientific I know :)

Seriously though, when people indicate PG is "hard", I hear, "if it was easy
everone would be doing it".

-$0.02

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com