Membuat Database dan Table di PostgreSQL

Belajar PostgreSQL ach....

Membuat database (dari baris perintah)
sihab@alisya-desktop:~$ createdb mmx_db

Membuat tabel (dari psql)
sihab@alisya-desktop:~$ psql mmx_db
mmx_db=# create table allowance (
meal integer not null,
transport integer not null,
nightshift integer not null,
overmeal integer not null,
extratime integer not null);

Menghapus kolom
mmx_db=# alter table allowance drop column extratime;

Mengisi table allowance
mmx_db=# insert into allowance values (8000,12000,8000,8000);

Melihat isi table allowance
mmx_db=# select * from allowance;
meal | transport | nightshift | overmeal
------+-----------+------------+----------
8000 | 12000 | 8000 | 8000
(1 row)