Academia JavaEE Workspace in Ubuntu

PostgreSQL

Install

createdb $USER

Schema

CREATE DATABASE academia;
CREATE USER academia WITH ENCRYPTED PASSWORD 'academia';
GRANT ALL PRIVILEGES ON DATABASE academia TO academia;

psql academia < academia.sql

References

• PostgreSQL