How to install, configure, and use PostgreSQL
I. Introduction to PostgreSQL
1. What is PostgreSQL?
PostgreSQL database is currently the most powerful open-source database and supports a wide range of data types (such as JSON, JSONB, and array types)
PostgreSQL is an open-source SQL database that supports standard SQL and allows users to connect to PostgreSQL via the JDBC driver for application development. The user extends the PostgreSQL function, allowing the developer to access the SEQUOIADB
Comparison between PostgreSQL and MySQL
Features
MySQL
PostgreSQL
Instance
Run the MySQL Command (mysqld) to start the instance. One instance can manage one or more databases. One server can run multiple mysqld instances.
Introduction of PostgreSQL
1, what is PostgreSQL
The PostgreSQL database is currently the most powerful open source database, supporting rich data types (such as JSON, JSONB type, array type), and custom types. And it provides a rich interface
PostgreSQL 9.5.1 official document Study Notes
This document is applicable to the latest version of PostgreSQL 9.5.1. I am new to PostgreSQL and may not miss this article. please correct me. With more understanding, this article [may] will be
1. Some time ago, I translated an article titled changing your website from MySQL to PostgreSQL. in fact, I was more interested in the specific operation of converting the background database of an application from MySQL to PostgreSQL, and did not
From: http://bbs.chinaunix.net/thread-1688208-1-1.html
Features
MySQL
PostgreSQL
Instance
Run the MySQL Command (mysqld) to start the instance. One instance can manage one or more databases. One server can run
Characteristics
Mysql
PostgreSQL
Instance
Launch the instance by executing the MySQL command (MYSQLD). One instance can manage one or more databases. A single server can run multiple mysqld instances. An instance manager
The content of this article complies with the CC copyright agreement, can be reproduced at will, but must be indicated in the form of Hyperlink original source and author information and copyright statement URL: www.penglixun.comtechdatabasemysql-vs-
Http://bbs.chinaunix.net/thread-1688208-1-1.html
Characteristics
Mysql
PostgreSQL
Instance
Launch the instance by executing the MySQL command (MYSQLD). One instance can manage one or more databases. A
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.