Difference between revisions of "PostgreSQL Adapter-nexj/scripts"

From CDOT Wiki
Jump to: navigation, search
Line 1: Line 1:
 
  <big><big>Working with scripts </big></big>
 
  <big><big>Working with scripts </big></big>
 
{{NexJ_Express Index}}
 
{{NexJ_Express Index}}
===postgresql_Setup.sql===
+
 
 +
==postgresql_Setup.sql==
 
: Through the process in postgresql_setup.sql, the database was created, initialized and tested:
 
: 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>
 
:: A database called 'test is created in PostgreSQL : <code> CREATE DATABASE test </code>

Revision as of 11:35, 10 December 2010

Working with scripts 

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 with password: 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);