Academia JavaEE Workspace in Ubuntu: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==References== * PostgreSQL") |
No edit summary |
||
| Line 1: | Line 1: | ||
==Java== | |||
==PostgreSQL== | |||
===Install=== | |||
<source lang="bash"> | |||
createdb $USER | |||
</source> | |||
===Schema=== | |||
<source lang="sql"> | |||
CREATE DATABASE academia; | |||
CREATE USER academia WITH ENCRYPTED PASSWORD 'academia'; | |||
GRANT ALL PRIVILEGES ON DATABASE academia TO academia; | |||
</source> | |||
psql academia < academia.sql | |||
==References== | ==References== | ||
* [[PostgreSQL]] | * [[PostgreSQL]] | ||
Revision as of 10:36, 5 January 2021
Java
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