Re: [GENERAL] psql and mysql

2005-04-03 Thread Jim C. Nasby
On Sat, Apr 02, 2005 at 06:23:56PM -0500, [EMAIL PROTECTED] wrote: > Clients aside, and as Christopher wrote, there are lots of differences > between the two systems. PostgreSQL supports higher-end Enterprise-level > RDBMS features. MySQL tends to be quicker. For example, and as just one MySQL is

Re: [GENERAL] psql and mysql

2005-04-02 Thread jcradock
Clients aside, and as Christopher wrote, there are lots of differences between the two systems. PostgreSQL supports higher-end Enterprise-level RDBMS features. MySQL tends to be quicker. For example, and as just one example, PostgreSQL can store and handle GIS data through PostGIS. MySQL's OGC-comp

Re: [GENERAL] psql and mysql

2005-04-02 Thread jcradock
A significant difference, and something that might be frustrating, is listing databases and database objects and describing tables. To list databases, type \l ...and hit RETURN. To list tables in the database you've logged in to, type \dt If you've got some familiarity with MySQL then querying

Re: [GENERAL] psql and mysql

2005-04-02 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("YL") wrote: > Dear List, > I'm new to Psql and very eager to learn the differences between these two > RDBMS. Well, you can find the documentation for PostgreSQL at , and you can find the documentation for M

[GENERAL] psql and mysql

2005-04-02 Thread YL
Dear List, I'm new to Psql and very eager to learn the differences between these two RDBMS. Any help is greatly appreciated. Thanks -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005 --