Postgres

Jump to bottom

koniiiik edited this page Nov 16, 2014 · 2 revisions

V postgres-e sa da nastavit odkial ma auto-increment generovat id-cka pomocou prikazu, nie že by ste to ever mali potrebovať...

ALTER SEQUENCE <meno_tabulky>_<meno_stlpca>_seq RESTART WITH 1000;

Ako vytvorit Postgres databazu

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