kyaruc memex

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== PosgreSQL QuickRef ======

PostgreSQL quick reference.

===== Create Role & DB =====
<code sql>
CREATE DATABASE <dbname>;
CREATE ROLE <rolename>;
ALTER USER <rolename> WITH PASSWORD '<password>';
ALTER USER <rolename> WITH LOGIN;
ALTER DATABASE <dbname> OWNER TO <rolename>;
GRANT ALL PRIVILEGES ON DATABASE <dbname> TO <rolename>;
</code>

===== Reset Serial Count =====
<code sql>
-- Reset sequence
ALTER SEQUENCE seq RESTART WITH 1;

-- update column to reference sequence
-- (not needed if the column in question is already
-- referenced by the sequence)
UPDATE t SET idcolumn=nextval('seq');
</code>

===== Add/Drop Constraint =====
Postgres names constraints on table creation in the following format: ''(table name)_(column name)_(constraint type)''.
<code sql>
ALTER TABLE <table> ADD CONSTRAINT <constraint_name> <constraint_expression>;
ALTER TABLE <table> DROP CONSTRAINT <constraint_name>;
</code>

kyaruc memex

User Tools

Site Tools

Page Tools