[
MAINHACK
]
Mail Test
BC
Config Scan
HOME
Create...
New File
New Folder
Viewing / Editing File: ALTER_DOMAIN.7
File is not writable. Editing disabled.
'\" t .\" Title: ALTER DOMAIN .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/> .\" Date: 2017-11-06 .\" Manual: PostgreSQL 9.2.24 Documentation .\" Source: PostgreSQL 9.2.24 .\" Language: English .\" .TH "ALTER DOMAIN" "7" "2017-11-06" "PostgreSQL 9.2.24" "PostgreSQL 9.2.24 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" ALTER_DOMAIN \- change the definition of a domain .\" ALTER DOMAIN .SH "SYNOPSIS" .sp .nf ALTER DOMAIN \fIname\fR { SET DEFAULT \fIexpression\fR | DROP DEFAULT } ALTER DOMAIN \fIname\fR { SET | DROP } NOT NULL ALTER DOMAIN \fIname\fR ADD \fIdomain_constraint\fR [ NOT VALID ] ALTER DOMAIN \fIname\fR DROP CONSTRAINT [ IF EXISTS ] \fIconstraint_name\fR [ RESTRICT | CASCADE ] ALTER DOMAIN \fIname\fR RENAME CONSTRAINT \fIconstraint_name\fR TO \fInew_constraint_name\fR ALTER DOMAIN \fIname\fR VALIDATE CONSTRAINT \fIconstraint_name\fR ALTER DOMAIN \fIname\fR OWNER TO \fInew_owner\fR ALTER DOMAIN \fIname\fR RENAME TO \fInew_name\fR ALTER DOMAIN \fIname\fR SET SCHEMA \fInew_schema\fR .fi .SH "DESCRIPTION" .PP \fBALTER DOMAIN\fR changes the definition of an existing domain\&. There are several sub\-forms: .PP SET/DROP DEFAULT .RS 4 These forms set or remove the default value for a domain\&. Note that defaults only apply to subsequent \fBINSERT\fR commands; they do not affect rows already in a table using the domain\&. .RE .PP SET/DROP NOT NULL .RS 4 These forms change whether a domain is marked to allow NULL values or to reject NULL values\&. You can only SET NOT NULL when the columns using the domain contain no null values\&. .RE .PP ADD \fIdomain_constraint\fR [ NOT VALID ] .RS 4 This form adds a new constraint to a domain using the same syntax as CREATE DOMAIN (\fBCREATE_DOMAIN\fR(7))\&. When a new constraint is added to a domain, all columns using that domain will be checked against the newly added constraint\&. These checks can be suppressed by adding the new constraint using the NOT VALID option; the constraint can later be made valid using \fBALTER DOMAIN \&.\&.\&. VALIDATE CONSTRAINT\fR\&. Newly inserted or updated rows are always checked against all constraints, even those marked NOT VALID\&. NOT VALID is only accepted for CHECK constraints\&. .RE .PP DROP CONSTRAINT [ IF EXISTS ] .RS 4 This form drops constraints on a domain\&. If IF EXISTS is specified and the constraint does not exist, no error is thrown\&. In this case a notice is issued instead\&. .RE .PP RENAME CONSTRAINT .RS 4 This form changes the name of a constraint on a domain\&. .RE .PP VALIDATE CONSTRAINT .RS 4 This form validates a constraint previously added as NOT VALID, that is, verify that all data in columns using the domain satisfy the specified constraint\&. .RE .PP OWNER .RS 4 This form changes the owner of the domain to the specified user\&. .RE .PP RENAME .RS 4 This form changes the name of the domain\&. .RE .PP SET SCHEMA .RS 4 This form changes the schema of the domain\&. Any constraints associated with the domain are moved into the new schema as well\&. .RE .PP You must own the domain to use \fBALTER DOMAIN\fR\&. To change the schema of a domain, you must also have CREATE privilege on the new schema\&. To alter the owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the domain\*(Aqs schema\&. (These restrictions enforce that altering the owner doesn\*(Aqt do anything you couldn\*(Aqt do by dropping and recreating the domain\&. However, a superuser can alter ownership of any domain anyway\&.) .SH "PARAMETERS" .PP .PP \fIname\fR .RS 4 The name (possibly schema\-qualified) of an existing domain to alter\&. .RE .PP \fIdomain_constraint\fR .RS 4 New domain constraint for the domain\&. .RE .PP \fIconstraint_name\fR .RS 4 Name of an existing constraint to drop or rename\&. .RE .PP \fINOT VALID\fR .RS 4 Do not verify existing column data for constraint validity\&. .RE .PP CASCADE .RS 4 Automatically drop objects that depend on the constraint\&. .RE .PP RESTRICT .RS 4 Refuse to drop the constraint if there are any dependent objects\&. This is the default behavior\&. .RE .PP \fInew_name\fR .RS 4 The new name for the domain\&. .RE .PP \fInew_constraint_name\fR .RS 4 The new name for the constraint\&. .RE .PP \fInew_owner\fR .RS 4 The user name of the new owner of the domain\&. .RE .PP \fInew_schema\fR .RS 4 The new schema for the domain\&. .RE .SH "NOTES" .PP Currently, \fBALTER DOMAIN ADD CONSTRAINT\fR and \fBALTER DOMAIN SET NOT NULL\fR will fail if the named domain or any derived domain is used within a composite\-type column of any table in the database\&. They should eventually be improved to be able to verify the new constraint for such nested columns\&. .SH "EXAMPLES" .PP To add a NOT NULL constraint to a domain: .sp .if n \{\ .RS 4 .\} .nf ALTER DOMAIN zipcode SET NOT NULL; .fi .if n \{\ .RE .\} .sp To remove a NOT NULL constraint from a domain: .sp .if n \{\ .RS 4 .\} .nf ALTER DOMAIN zipcode DROP NOT NULL; .fi .if n \{\ .RE .\} .PP To add a check constraint to a domain: .sp .if n \{\ .RS 4 .\} .nf ALTER DOMAIN zipcode ADD CONSTRAINT zipchk CHECK (char_length(VALUE) = 5); .fi .if n \{\ .RE .\} .PP To remove a check constraint from a domain: .sp .if n \{\ .RS 4 .\} .nf ALTER DOMAIN zipcode DROP CONSTRAINT zipchk; .fi .if n \{\ .RE .\} .PP To rename a check constraint on a domain: .sp .if n \{\ .RS 4 .\} .nf ALTER DOMAIN zipcode RENAME CONSTRAINT zipchk TO zip_check; .fi .if n \{\ .RE .\} .PP To move the domain into a different schema: .sp .if n \{\ .RS 4 .\} .nf ALTER DOMAIN zipcode SET SCHEMA customers; .fi .if n \{\ .RE .\} .SH "COMPATIBILITY" .PP \fBALTER DOMAIN\fR conforms to the SQL standard, except for the OWNER, RENAME, SET SCHEMA, and VALIDATE CONSTRAINT variants, which are PostgreSQL extensions\&. The NOT VALID clause of the ADD CONSTRAINT variant is also a PostgreSQL extension\&. .SH "SEE ALSO" CREATE DOMAIN (\fBCREATE_DOMAIN\fR(7)), DROP DOMAIN (\fBDROP_DOMAIN\fR(7))
Save Changes
Cancel / Back
Close ×
Server Info
Hostname: server05.hostinghome.co.in
Server IP: 192.168.74.40
PHP Version: 7.4.33
Server Software: Apache
System: Linux server05.hostinghome.co.in 3.10.0-962.3.2.lve1.5.81.el7.x86_64 #1 SMP Wed May 31 10:36:47 UTC 2023 x86_64
HDD Total: 1.95 TB
HDD Free: 691.41 GB
Domains on IP: N/A (Requires external lookup)
System Features
Safe Mode:
Off
disable_functions:
None
allow_url_fopen:
On
allow_url_include:
Off
magic_quotes_gpc:
Off
register_globals:
Off
open_basedir:
None
cURL:
Enabled
ZipArchive:
Disabled
MySQLi:
Enabled
PDO:
Enabled
wget:
Yes
curl (cmd):
Yes
perl:
Yes
python:
Yes
gcc:
Yes
pkexec:
No
git:
Yes
User Info
Username: itsweb
User ID (UID): 1619
Group ID (GID): 1621
Script Owner UID: 1619
Current Dir Owner: N/A