PostgreSQL literacy tutorial

Time:2020-5-22

Download PostgreSQL at this link.

When installing, remember the initial password you set for user Postgres and the default port number 5432, which you need to use later.

Then install the graphical management UI pgadmin, which can be obtained from this link.

After installation, log in to pgadmin and change the port in the server connection to the default 5432:

Connect to the server successfully, and then create a new table:

Maintain three columns for the table:

Use script to insert some test data:

After the test data is inserted, query the data just inserted through select *.

The effect is the same as using the command line tool PSQL.

Insert a test data in the command line:

Insert results:

Recommended Today

Python basics Chinese series tutorial · translation completed

Original: Python basics Python tutorial Protocol: CC by-nc-sa 4.0 Welcome anyone to participate and improve: a person can go very fast, but a group of people can go further. Online reading Apache CN learning resources catalog introduce Seven reasons to learn Python Why Python is great Learn Python introduction Executing Python scripts variable character string […]