SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 08:23 PM
| ||||
| ||||
 test please ignore -- 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster      |
|
04-08-2008, 08:23 PM
| |||
| |||
| psql and mysql 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org |
|
04-08-2008, 08:23 PM
| |||
| |||
| Re: psql and mysql Martha Stewart called it a Good Thing when elim@pdtnetworks.net ("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 <http://www.postgresql.org/>, and you can find the documentation for MySQL(tm) at <http://www.mysql.com/>. They are quite different systems; to get any sort of comprehensive view, you will need to comprehensively read both sets of documentation. -- select 'cbbrowne' || '@' || 'gmail.com'; http://linuxfinances.info/info/x.html Wiener's Law of Libraries: There are no answers, only cross references. |
|
04-08-2008, 08:23 PM
| |||
| |||
| Re: psql and mysql 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 database objects should be easy in PostgreSQL, altough PostgreSQL does obviously support some features and thus some commands not available in MySQL. There will be some learning there, possibly, but I think you'll find it easy. Type \? ....and press RETURN to see the full set of options. I definitely recommend reading the docs: http://www.postgresql.org/docs/curre.../app-psql.html Enjoy! Jim > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > ----- James Cradock, jcradock@me3.com ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org |
|
04-08-2008, 08:23 PM
| |||
| |||
| Re: psql and mysql 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-compatible OGC support was introduced in the latest production-worthy release. Both MySQL and PostgreSQL are stable and easy to use and well supported. If you're trying to learn something, I definitely recommend reading the documentation. If you have some specific task in mind and think PostgreSQL might be the better fit, post a question to the list. Jim > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > ----- James Cradock, jcradock@me3.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster |
|
04-08-2008, 08:24 PM
| ||||
| ||||
| Re: psql and mysql On Sat, Apr 02, 2005 at 06:23:56PM -0500, jcradock@me3.com 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 generally only quicker if you don't care about your data (MyISAM tables) and if you aren't hitting it with multiple clients. -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
Linear Mode
