Tao va xoa CSDL trong postgresql

---- Tao CSDL trong postgresql
1. sudo -s -u postgres
2. psql
3. CREATE DATABASE name_of_database WITH OWNER = name_of_user ENCODING = 'UTF8';
4. \q
5. exit

---- Delete CSDL trong postgresql
1. sudo -s -u postgres
2. psql
3. DROP DATABASE name_of_database;
4. \q
5. exit

-- Xem danh sach CSDL hien co
select d.datname as name from pg_catalog.pg_database d;

No comments: