Search “alter_table” — BetterMan

Search

Tip: Use ssh_config or systemd.unit for dotted names.

Did you mean: alter_tablespace, alter_foreign_table, table, alter_rule?

change the definition of a table

NAME ALTER_TABLE - change the definition of a table SYNOPSIS ALTER TABLE [ IF EXISTS ] [ ONLY ... name [ * ] action [, ... ] ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ] RENAME [ …

alter_tablespace(7)
change the definition of a tablespace
```
NAME ALTER_TABLESPACE
```

alter_foreign_table(7)

change the definition of a foreign table

operations. See the similar form of ALTER TABLE for more details. SET ( attribute_option = value ... options. See the similar form of ALTER TABLE for more details. SET STORAGE This…

alter_trigger(7)

change the definition of a trigger

name of an existing trigger to alter. table_name The name of the table ... disable a trigger is provided by ALTER TABLE , not by ALTER TRIGGER , because ALTER TRIGGER

create_table(7)

define a new table

mode is main or extended. (See ALTER TABLE ( ALTER_TABLE (7)) for information on column ... table. It is possible to use ALTER TABLE ATTACH/DETACH PARTITION to perform these operat…

create_policy(7)

define a new row-level security policy for a table

enabled on the table (using ALTER TABLE ... ENABLE ROW LEVEL SECURITY ) in order for created ... DROP POLICY ( DROP_POLICY (7)), ALTER TABLE ( ALTER_TABLE

alter_type(7)

change the definition of a type

columns created in the future. See ALTER TABLE ( ALTER_TABLE (7)) to change the TOAST

drop_table(7)

remove a table

PostgreSQL extension. SEE ALSO ALTER TABLE ( ALTER_TABLE (7)), CREATE TABLE ( CREATE_TABLE

alter_view(7)

change the definition of a view

false. NOTES For historical reasons, ALTER TABLE can be used with views ... only variants of ALTER TABLE that are allowed with views are equivalent to the ones

alter_index(7)

change the definition of an index

These operations are also possible using ALTER TABLE . ALTER INDEX is in fact just ... alias for the forms of ALTER TABLE that apply to indexes. There was formerly

alter_sequence(7)

change the definition of a sequence generator

setval calls. For historical reasons, ALTER TABLE can be used with sequences ... only variants of ALTER TABLE that are allowed with sequences are equivalent to the forms

alter_materialized_view(7)

change the definition of a materialized view

subset of those available for ALTER TABLE , and have the same meaning when used ... materialized views. See the descriptions for ALTER TABLE for details. PARAMETERS name The name (…

drop_policy(7)

remove a row-level security policy from a table

level security enabled via ALTER TABLE , then the default-deny policy will be used. ALTER

analyze(7)

collect statistics about a database

column statistics target with ALTER TABLE ... ALTER COLUMN ... SET STATISTICS . The target value sets ... determined manually and then installed with ALTER TABLE ... ALTER COLUMN .…

create_index(7)

define a new index

value for parallel_workers via ALTER TABLE directly controls how many parallel worker processes will ... Setting parallel_workers to 0 via ALTER TABLE will disable parallel index b…

alter_rule(7)

change the definition of a rule

name of an existing rule to alter. table_name The name (optionally schema-qualified

alter_policy(7)

change the definition of a row-level security policy

name of an existing policy to alter. table_name The name (optionally schema-qualified

cluster(7)

cluster a table according to an index

WITHOUT CLUSTER forms of ALTER TABLE to set the index to be used for future

create_foreign_table(7)

define a new foreign table

parent table. (See also ALTER TABLE ATTACH PARTITION .) CONSTRAINT constraint_name An optional name

create_type(7)

define a new data type

other strategies for individual columns using ALTER TABLE SET STORAGE. The like_type parameter provides

20 results loaded