Installazione#
- Installare i seguenti pacchetti: - postgresql - postgresql-serverrcpostgresql start chkconfig postgresql on su postgres psql postgres postgres=# create user root with superuser login; CREATE ROLE postgres=# create user sqlgrey with password 'iehQ6Ffshvta93eP'; CREATE ROLE postgres=# create database sqlgrey owner sqlgrey; CREATE DATABASE postgres=#
Comandi base#
settare uno schema(db2prod):SET search_path TO db2prod,public;Connettere a DB:
psql -U java rub35
Add new attachment
Only authorized users are allowed to upload new attachments.