How to create/drop a PostgreSQL Database
Database can be create using -
Command - create database database_name owner owner_name;
Utility - Createdb db_name
C:\Users\amits>createdb -U postgres db1
Password:
C:\Users\amits>psql -U postgres
Password for user postgres:
psql (16.2)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
postgres=# \l
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-----------+----------+----------+-----------------+----------------------------+----------------------------+------------+-----------+-----------------------
amit | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | |
db1 | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | |
postgres | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | |
template0 | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(5 rows)
postgres=# create database db2 owner postgres;
CREATE DATABASE
postgres=# \l
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-----------+----------+----------+-----------------+----------------------------+----------------------------+------------+-----------+-----------------------
amit | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | |
db1 | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | |
db2 | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | |
postgres | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | |
template0 | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(6 rows)
postgres=# select datname,oid from pg_database;
datname | oid
-----------+-------
postgres | 5
amit | 24578
template1 | 1
template0 | 4
db1 | 24587
db2 | 24588
C:\Users\amits>dropdb -U postgres db2
Password:
C:\Users\amits>psql -U postgres
Password for user postgres:
psql (16.2)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
postgres=# \l
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-----------+----------+----------+-----------------+----------------------------+----------------------------+------------+-----------+-----------------------
amit | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | |
postgres | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | |
template0 | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | English_United States.1252 | English_United States.1252 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(4 rows)
Comments
Post a Comment