Skip to Main Content
Building Java Enterprise Applications
book

Building Java Enterprise Applications

by Brett McLaughlin
March 2002
Intermediate to advanced content levelIntermediate to advanced
320 pages
8h 58m
English
O'Reilly Media, Inc.
Content preview from Building Java Enterprise Applications

PostgreSQL

PostgreSQL, along with mySQL, is a popular open source option for Unix-flavored systems like Linux, Solaris, and my own Mac OS X. You can download the distribution from http://www.postgresql.org (for U.S. users, the best mirror site is http://www.us.postgresql.org). Installation instructions are included in the distribution and are also available at the web site. Install the database and then start it as shown here:

[localhost:~] postgres% /usr/local/pgsql/bin/postmaster -D /usr/local/pqsql/data

Once you’ve got the database running, presumably with the “postgres” user (as the installation instructions recommend), you need to create the Forethought database:

[localhost:~] postgres% /usr/local/pgsql/bin/createdb forethought
CREATE DATABASE

The next step is to connect to the database and run your SQL scripts against it. This is done with the psql tool, a handy utility for just this purpose. Run this script, specifying the database to connect to and the file with SQL to execute:

[localhost:~] postgres% psql -f database_schema_users.sql forethought NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'user_types_pkey' for table 'user_types' psql:database_schema_users.sql:5: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'user_types_pkey' for table 'user_types' CREATE NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'offices_pkey' for table 'offices' psql:database_schema_users.sql:12: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Enterprise Web Programming with Java

Enterprise Web Programming with Java

O'Reilly Media, Inc.
Modernizing Enterprise Java

Modernizing Enterprise Java

Markus Eisele, Natale Vinto

Publisher Resources

ISBN: 0596001231Supplemental ContentCatalog PageErrata