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

Parameter	Description
table_name	The 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)

Related topics

SHOW CREATE MATERIALIZED VIEW

SHOW CREATE VIEW