From: | "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com> |
---|---|
To: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> |
Cc: | "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-advocacy(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Is my MySQL Gaining ? |
Date: | 2003-12-28 18:20:53 |
Message-ID: | 1072635653.3fef1f0587bbb@webmail.vcsn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Keith C. Perry | 2003-12-28 18:50:49 | Re: Is my MySQL Gaining ? |
Previous Message | Casey Allen Shobe | 2003-12-28 18:00:52 | Re: PGSQL 7.4 tips, was Re: Is my MySQL Gaining ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Keith C. Perry | 2003-12-28 18:50:49 | Re: Is my MySQL Gaining ? |
Previous Message | Casey Allen Shobe | 2003-12-28 18:00:52 | Re: PGSQL 7.4 tips, was Re: Is my MySQL Gaining ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Keith C. Perry | 2003-12-28 18:50:49 | Re: Is my MySQL Gaining ? |
Previous Message | Casey Allen Shobe | 2003-12-28 18:00:52 | Re: PGSQL 7.4 tips, was Re: Is my MySQL Gaining ? |