Differences

This shows you the differences between two versions of the page.

--- quickref:postgres [2025-11-04 Tue 14:16] – created theorytoe
+++ quickref:postgres [2025-12-23 Tue 20:38] (current) – [Create Role & DB] rolename missing theorytoe
@@ Line 7: / Line 7: @@
 CREATE DATABASE <dbname>;
 CREATE ROLE <rolename>;
-ALTER USER backend WITH PASSWORD '<password>';
+ALTER USER <rolename> WITH PASSWORD '<password>';
-ALTER USER backend WITH LOGIN;
+ALTER USER <rolename> WITH LOGIN;
 ALTER DATABASE <dbname> OWNER TO <rolename>;
 GRANT ALL PRIVILEGES ON DATABASE <dbname> TO <rolename>;
@@ Line 23: / Line 23: @@
 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