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)
The SQL input consists of a series of commands . An order consists of a series of tokens , with a semicolon (";") End. The termination of the input stream also ends a command. Which tokens are valid depends on the syntax of the particular command.A
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
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
PostgreSQL-related software, libraries, tools, and resource collections.Backup
WAL-E-Simple continuous archiving for Postgres to S3, Azure, or Swift by Heroku
Barman-backup and Recovery Manager for Postgres by 2ndQuadrant
Gui
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
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
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.