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, database '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 PostgreSQL documentation] - [http://www.postgresql.org/docs/9.0/interactive/manage-ag-createdb.html]:: To create a <code>user</code> along with <code>password</code>: <code> CREATE USER test WITH PASSWORD 'test'; </code>:: Login to the <code>test</code> database with <code>test</code> username:: To create a <code>table</code>, first you need to crate a <code> schema </code> inside the database test, with particular user name 'test' <code> CREATE SCHEMA TEST AUTHORIZATION TEST;</code>
=== 3- Create the extended PostgreSQL source files ===