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
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
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
Recently prepared for PostgreSQL database development related knowledge, this article summarizes the PPT content through the blog record sharing, this essay's main content is to introduce the PostgreSQL database basic information, and how to use the
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
Now, when talking about free databases, most people may first think of MySQL. Indeed, MySQL has been applied in many domestic fields, especially in website setup. However, PostgreSQL is actually the most powerful, rich, and complex free database.
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.