1
edit
Changes
Created page with ' <big><big> PostgreSQL Adapter for NexJ - Working with Scripts </big></big> {{MinNexJ_Express Index}} ==postgresql_Setup.sql== : Through the process in postgresql_setup.sql, th…'
<big><big> PostgreSQL Adapter for NexJ - Working with Scripts </big></big>
{{MinNexJ_Express Index}}
==postgresql_Setup.sql==
: 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>