1
edit
Changes
Created page with ': Through the process in postgresql_setup.sql, the database was created, initialized and tested: :: A database called 'test is created in PostgreSQL : <code> CREATE DATABASE test…'
: Through the process in postgresql_setup.sql, the database was created, initialized and tested:
:: A database called 'test is created in PostgreSQL : <code> CREATE DATABASE test </code>
:: To create a <code>user</code> along with <code>password</code>: <code> CREATE USER test WITH PASSWORD 'test'; </code>
:: Login to the database 'test' with username 'test': <code> psql -U test test </code>
:: Create a <code> Schema </code> called 'test' inside the database 'test' with particular owner 'test': <code> CREATE SCHEMA test AUTHORIZATION test;</code>
:: Create a <code>table</code> called 'Mutex' with primary key: <code> CREATE TABLE test.Mutex(id INT PRIMARY KEY); </code>
:: Insert a value into the primary key: <code> INSERT INTO test.Mutex(id) VALUES (1); </code>
:: A database called 'test is created in PostgreSQL : <code> CREATE DATABASE test </code>
:: To create a <code>user</code> along with <code>password</code>: <code> CREATE USER test WITH PASSWORD 'test'; </code>
:: Login to the database 'test' with username 'test': <code> psql -U test test </code>
:: Create a <code> Schema </code> called 'test' inside the database 'test' with particular owner 'test': <code> CREATE SCHEMA test AUTHORIZATION test;</code>
:: Create a <code>table</code> called 'Mutex' with primary key: <code> CREATE TABLE test.Mutex(id INT PRIMARY KEY); </code>
:: Insert a value into the primary key: <code> INSERT INTO test.Mutex(id) VALUES (1); </code>
