When PostgreSQL is deployed on CentOS, some operating system parameters need to be set up, and some of the official documents are listed (portal). In addition to these, there are other settings, such as the maximum number of processes allowed by a
First, get the system time function
1.1 Get current full time
code is as follows
copy code
Select now (); david=# Select Now (); now ------------------------- ------ 2013-04-12 15:3
Logged in user
After PostgreSQL is installed on CentOS 7, a postgres user is created by default. To use PostgreSQL, we need to switch to that user first:
$ sudo-i-U postgres
Then enter:
$ psql
You can enter the PostgreSQL command line. The
0. Reference documents and Introduction:1. The Prophet Community Chybeta the great god--postgresql Remote Code execution Vulnerability Analysis and utilization-"cve-2018-1058"--a article2, the blog Park Hunchill--mac under the installation and use
Constraint type: Check constraint, non-null constraint, UNIQUE constraint, primary key, foreign key1. CHECK constraintsSetting a value in a field must satisfy the condition of the constraint expression.Example: Limiting the age of people in 0~120 ,
PostgreSQL finally released the 10.0 official version! Download the compressed version of the updated version of the machine, and then open pgadmin always Error "The application server could not be contacted.", tried several methods on the web,
Recently the company with PostgreSQL this database, see online said this database is still good, I used a bit, I was using Java to connect a database.In fact, each database is connected in roughly the same way, only with different drivers, with
When creating a table, the table name and field name must be all lowercase , and then the query will not be error-able, either full-capitalization or full-lowercase, or camel mode. As long as there are uppercase letters in the name, or all uppercase,
First, configuration instructions:Role Name: User011.user01 Permission Description:Connect to test database, cannot connect to other database when unauthorized;In the specified schema, create \ View \ Delete The table to view the object in the
When learning hibernate, the database uses PostgreSQL, the first lesson is thrown wrong, user entity mapping is not alive or alive cannot export the table. Always prompt this sentence:Error:syntax ERROR at or near "User". Later found that if the
PostgreSQL configuration file optimizationConfiguration fileThe default configuration profile is the postgresql.conf file that is saved in the/etc/postgresql/version/main directoryIf you want to see if the parameter modification takes effect, you
Let's say we have a bank. Our bank wants to give each account for each user a unique name, for instance, "Personal" or "Checking." How can we do sure each account have a unique name for each user?ADD UNIQUE constraint when create a new table:CREATE
--The following description does not remember where it was copied?!Table partitioning is the logical separation of a large table into physical multiple small chunks, table partitioning provides several benefits:1. Some types of query performance can
If we don ' t already has PostgreSQL installed, we must install it.$ sudo apt-get install PostgreSQLThis command installs the PostgreSQL server and various other packages.$ sudo update-rc.d-f postgresql removeremoving any system startup links
The focus of recent work has been on database design, with this opportunity to take time to sort out some of my PostgreSQL Database Understanding, but also for the recent period of time to learn a summary. For many people who may not have heard of
Processing of null values in PostgreSQL When a field value is null in the addition, subtraction, multiplication, division, and Division operations, the output results often disappoint us and we cannot get the expected values, you can use coalesce to
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service