PostgreSQL Note

Reading time ~1 minute

This note is about the problems that I met while using PostgreSQL.

Install

Follow official user guide.

Access

// Modify pg_hba.conf
$ sudo vim /etc/postgresql/10/main/pg_hba.conf

// local all postgress trues

// Restart service
$ sudo service postgresql restart

// Connect
$ psql -U postgres

Create User

$ CREATE ROLE username WITH LOGIN PASSWORD 'password';

Grant

$ ALTER ROLE username CREATEDB;

Create Database

$ CREATE DATABASE db_name;

竟然无法拒绝你的打赏

微信支付

TypeScript Notes

This note is about the JavaScript. Continue reading

Deep Learning

Published on October 01, 2019

React Native

Published on April 01, 2019