Skip to main content

SHOW CREATE TABLE

Use the SHOW CREATE TABLE command to see what query was used to create the specified table.

Syntax

SHOW CREATE TABLE table_name;

Parameters

ParameterDescription
table_nameThe table to show the query of.

Example

CREATE TABLE IF NOT EXISTS taxi_trips(
id VARCHAR,
distance DOUBLE PRECISION,
city VARCHAR
) WITH (appendonly = 'true');

SHOW CREATE TABLE taxi_trips;

Here is the result. Note that the IF NOT EXISTS clause is omitted while the WITH option is preserved.

   Name    |                 Create Sql
-----------+---------------------------------------------
public.taxi_trips | CREATE TABLE taxi_trips (id CHARACTER VARYING, distance DOUBLE, city CHARACTER VARYING) WITH (appendonly = 'true')
(1 row)

SHOW CREATE MATERIALIZED VIEW

SHOW CREATE VIEW

Help us make this doc better!