Postgresql – databases – Programowanie

Utworzenie bazy danych :

# su - postgres

# createdb mydatabase

# su - postgres
# psql

CREATE DATABASE mydatabase;

\q
exit

CREATE DATABASE mydatabase
  OWNER = username
  TEMPLATE = template0
  ENCODING = 'UTF8'
  LC_COLLATE = 'pl_PL.UTF-8'    -- błąd polskich znaków
  LC_CTYPE = 'pl_PL.UTF-8';     -- błąd

-- -W pyta o hasło

# psql -U username -d mydatabase -W

Aby odrębnie przypisać usera:

ALTER DATABASE mydatabase OWNER TO username;

GRANT CONNECT ON DATABASE mydatabase  TO username;
GRANT USAGE ON SCHEMA public TO username;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO username;
GRANT ALL PRIVILEGES ON DATABASE mydatabase  TO username;

Lista baz danych i ustawienia

# psql

\l    lub   \list