1
edit
Changes
→2- Create a PostgreSQL database through some scripts
=== 2- Create a PostgreSQL database through some scripts===
: Through the process in postgresql_setup.sql, ::: A database called 'test' is created. * Creating database [http://www.postgresql.org/files/documentation/books/aw_pgsql/node227.html]:: @ [http://www.postgresql.org/docs/9.0/interactive/creating-cluster.html in PostgreSQL documentation] - [http:<code> CREATE DATABASE test <//www.postgresql.org/docs/9.0/interactive/manage-ag-createdb.html]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> database with :: Create a <code>testSchema </code> username:called 'test' inside the database 'test' with particular owner 'test': To create a <code>tableCREATE SCHEMA test AUTHORIZATION test;</code>, first you need to crate :: Create a <code> schema table</code> inside the database test, with particular user name called 'testmutex' with primary key: <code> CREATE SCHEMA TEST AUTHORIZATION TESTTABLE test.Mutex(id INT PRIMARY KEY);</code>
=== 3- Create the extended PostgreSQL source files ===