Difference between revisions of "ALTER TABLE"

From wikieduonline
Jump to navigation Jump to search
 
(9 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
* https://www.postgresql.org/docs/current/sql-altertable.html
 +
ALTER TABLE tablename ADD [[CONSTRAINT]] constraintname UNIQUE (columns);
  
  ALTER TABLE tablename ADD [[CONSTRAINT]] constraintname UNIQUE (columns);
+
  ALTER TABLE tablename OWNER TO "new-owner";
 +
 
 +
REVOKE ALL ON accounts FROM PUBLIC;
  
 +
ALTER TABLE … SET ([[toast]]_tuple_target = N)
  
 +
== Related ==
 +
* [[List tables]]: <code>[[\dt]]</code>
 +
* <code>[[Insert into]]</code>
 +
* <code>[[Create user]]</code>
 +
* <code>[[Must be owner of table]]</code>
  
 
== See also ==
 
== See also ==

Latest revision as of 10:05, 4 November 2024

Advertising: