25. Toad Notes Go language--postgrelsql database use

This is a created article in which the information may have evolved or changed.

25. Toad Notes Go language--postgrelsql database use

Download Address: https://www.postgresql.org/download/

Take the Windows version for example here.

After downloading, double-click Install.

Postgresql-9.5.3-1-windows-x64.exe

The installation process enters the password and port number.

Use

After the installation is complete, there is a phadmin graphical tool as shown in Figure 1:

Command line Management

Once the installation is complete, bring your own command line management, as shown in Figure 2

Create DATABASE test:

#create database test;

Toggle Data

#\c Test

Link to database test

To create a user:

Create user Astaxie with password ' Astaxie ';

Log in to the database and assign values:

Grant all privileges on userinfo Toastaxie;