Difference between revisions of "User:Minooz/PostgreSQL Adapter-nexj/scripts"
(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…') |
(No difference)
|
Latest revision as of 15:50, 13 December 2010
PostgreSQL Adapter for NexJ - Working with Scripts
Min NexJ Express | JSON_Adapter | Continuous Integration for NexJ Express Code | REST Server | PostgreSQL Adapter |
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 :
CREATE DATABASE test
- To create a
user
along withpassword
:CREATE USER test WITH PASSWORD 'test';
- Login to the database 'test' with username 'test':
psql -U test test
- Create a
Schema
called 'test' inside the database 'test' with particular owner 'test':CREATE SCHEMA test AUTHORIZATION test;
- Create a
table
called 'Mutex' with primary key:CREATE TABLE test.Mutex(id INT PRIMARY KEY);
- Insert a value into the primary key:
INSERT INTO test.Mutex(id) VALUES (1);
- A database called 'test is created in PostgreSQL :