PostgreSQL Database Basic Operations

PostgreSQL Learning Site

1. Create user

1 2 3 4 5

Sudo-s-U postgres Psql postgres# CREATE USER xxxx1 with PASSWORD ' xxxx '; postgres# CREATE DATABASE xxxx2; postgres# GRANT all privileges on the DATABASE xxxx2 to xxxx1;

1. Change Password

   1	Alter user postgres with password ' foobar ';

2. Create a database

1 2 3 4 5

Createdb--encoding=utf8--owner=foo--template=template_postgis-ufoo Parameter:--encoding=utf8 sets the character set of the database --owner=foo to set the owner of the database --tmplate=template_postgis set up a template to build a library that supports spatial data operations --ufoo creating a database with Foo user identity

PostgreSQL Database Basic Operations