NAME CREATE_TABLE - define a new table SYNOPSIS CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE ... name [, ... ] ) ] | SET DEFAULT [ ( column_name [, ... ] ) ]…NAME CREATE_TABLE_AS - define a new table from the results of a query SYNOPSIS ... query [ WITH [ NO ] DATA ] DESCRIPTION CREATE TABLE AS creates a table and fills it withpass tablespace_name to CREATE DATABASE , CREATE TABLE , CREATE INDEX or ADD CONSTRAINT to have ... ALSO CREATE DATABASE ( CREATE_DATABASE (7)), CREATE TABLE ( CREATE_TABLE (7)), C…table, using the same syntax as CREATE TABLE . If IF NOT EXISTS is specified ... existing identity column. See CREATE TABLE for details. Like SET DEFAULT, these forms only affecttemporary table. Refer to CREATE TABLE ( CREATE_TABLE (7)) for details. UNLOGGED If specified ... unlogged table. Refer to CREATE TABLE ( CREATE_TABLE (7)) for details. new_table T…CREATE MATERIALIZED VIEW is similar to CREATE TABLE AS , except that it also remembers ... view; see Storage Parameters in the CREATE TABLE ( CREATE_TABLE (7)) documentation for mo…future version of PostgreSQL. EXAMPLES Create table t1 with two functionally dependent columns, i.e., knowledge ... statistics are built on those columns: CREATE TABLE t1 ( a int, …tables. See the similar form of CREATE TABLE for more details. PARTITION OF parent_table ... values. See the similar form of CREATE TABLE for more details. Note thatstatus AS ENUM ('new', 'open', 'closed'); CREATE TABLE bug ( id serial, description text, status ... function, OUTPUT = my_box_out_function ); CREATE TABLE myboxes ( id integer, de…timing of the trigger. See the CREATE TABLE ( CREATE_TABLE (7)) documentation for details ... other SQL commands, such as CREATE TABLE , as the triggered action. This limitationapplied to partitioned tables; see CREATE TABLE ( CREATE_TABLE (7)). CONCURRENTLY When this option ... created in the future using CREATE TABLE ... PARTITION OF will automatically …created within the schema. Currently, only CREATE TABLE , CREATE VIEW , CREATE INDEX , CREATE SEQUENCE , CREATE ... view within it: CREATE SCHEMA hollywood CREATE TABLE films (titl…INSERT , UPDATE , DELETE , MERGE , CREATE TABLE AS , or EXECUTE statement without letting the command affect ... UPDATE , DELETE , MERGE , VALUES , EXECUTE , DECLARE , CREATE TABLE…VALUE ~ '^\d{5}-\d{4}$' ); CREATE TABLE us_snail_addy ( address_id SERIAL PRIMARYcolumn value to an updatable view: CREATE TABLE base_table (id int, ts timestamptz); CREATESee the file