OpenUnix - to BSD or not to BSD

PostgreSQL

logging to the "postgres" database as "psql" user

$ psql -U pgsql postgres
psql (9.6.1)
Type "help" for help.

creating database
=# CREATE DATABASE sherwood; CREATE DATABASE

creating user
=# CREATE USER brtuck WITH PASSWORD 'fatbelly'; CREATE ROLE
grant access to Brother Tuck
=# GRANT ALL PRIVILEGES ON DATABASE sherwood to brtuck; GRANT
grant privileges to Brother Tuck

There are several different kinds of privilege: SELECT, INSERT, UPDATE, DELETE, RULE, REFERENCES, TRIGGER, CREATE, TEMPORARY, EXECUTE, and USAGE, we will grant him some:
=# GRANT SELECT ON DATABASE sherwood to brtuck; GRANT
creating a table
=# mysql> CREATE TABLE robber (# ( id integer UNIQUE, (# name text NOT NULL, (# weapon_id integer, (# armor_id integer, (# CONSTRAINT robber_id_pkey PRIMARY KEY (id));
examinig the table
# \d robber Table "robber" Attribute | Type | Modifier ------------+---------+---------- id | integer | not null name | text | not null weapon_id | integer | armor_id | integer | Index: robber_id_pkey
altering the table (adding a column)
=# ALTER TABLE robbers -# ADD birthdate date; ALTER =# \d robber Table "robber" Attribute | Type | Modifier -------------+---------+---------- id | integer | not null name | text | not null weapon_id | integer | armor_id | integer | birthdate | date | Index: robber_id_pkey
dropping the table
=# DROP TABLE robbers; DROP DATABASE
renaming the table
=# ALTER TABLE robbers RENAME TO woodfolks; ALTER
renaming a column
=# ALTER TABLE robbers -# RENAME COLUMN birthdate TO date_of_birth; ALTER
Translator from mysql to postgresql:

mysql: SHOW TABLES postgresql: \d postgresql: SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'; mysql: SHOW DATABASES postgresql: \l postgresql: SELECT datname FROM pg_database; mysql: SHOW COLUMNS postgresql: \d table postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table'; mysql: DESCRIBE TABLE postgresql: \d+ table postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table';

Sources: http://postgresguide.com/setup/users.html, http://www.commandprompt.com/ppbook/c4890.htm, http://wiki.netbsd.org/pkgsrc/how_to_install_a_postgresql_server/#index7h1, http://www.linuxscrew.com/2009/07/03/postgresql-show-tables-show-databases-show-columns/

Openunix.eu

PostgreSQL