PostgreSQL Literacy Tutorials

Download PostgreSQL on this link.

When installing, remember the initial password you set for user Postgres, as well as 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 server connection to the default of 5432:

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

Maintain three columns for the table:

Insert some test data using script:

After the test data is inserted, query the data you just inserted by using SELECT *.

The effect is consistent with the effect of using the command line tool Psql.

Insert a test data in the command line:

Insert Result:

To get more original Jerry's technical articles, please follow the public number "Wang Zixi" or scan the QR code below:

PostgreSQL Literacy Tutorials