PostgreSQL Literacy course

Download PostgreSQL from 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.

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 value of 5432:

Successfully connect to the server, then create a new Table:

Maintain three columns for the table:

Use Script to insert some test data:

After testing the data insertion, query the data you just inserted through SELECT *.

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

Insert a test data on the command line:

Insert result:

For more original Jerry technical articles, please follow the official account "Wang Zixi" or scan the following QR code: