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
DescriptionI am using the root user login at the terminal, if the non-root user, that in the command before the need to add "sudo", you understand ...First step: install PostgreSQL under Ubuntu 1. Installing with Apt-get install[Email
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
There are a variety of Installation manuals for each platform to be installed. You can search for details in google. Here is the Installation Method On debian, ubuntu class: aptitudeinstallpostgresql # This is the database aptitudeinstallpgadmin3 #
DescriptionI am using the root user login at the terminal, if the non-root user, that in the command before the need to add "sudo", you understand ...First step: Install PostgreSQL under Ubuntu1. Installing with Apt-get Install[Email protected]:~#
Document directory
Supported Data Types
PostgreSQL is a widely used free and open source database. Compared with MySQL, PostgreSQL is more suitable for complicated enterprise computing tasks. MySQL is more widely used in the Internet field,
PostgreSQL has a wide range of data types available. Users can use the CREATE type command to Add new data types to PostgreSQL. Table 8-1 shows all the built-in common data types. Most of the optional names listed in the aliases column are names
Data type of PostgreSQL databasePostgreSQL supports a variety of data types, including integer types, floating-point types, Arbitrary precision values, datetime types, string types, binary types, Boolean types, and array types.1, Integer
PostgreSQL tutorial (6): Functions and operators (2), postgresql Operators
6. Pattern Matching:
PostgreSQL provides three methods for implementing pattern matching: SQL LIKE operator, closer SIMILAR TO operator, and POSIX-style regular expression.1.
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.