Answers for "psql get create table statement"

SQL
1

postgresql create table as select

CREATE TABLE films_recent AS
  SELECT * FROM films WHERE date_prod >= '2002-01-01';
Posted by: Guest on November-27-2020
0

show create table in postgresql

pg_dump -t 'schema-name.table-name' --schema-only database-name
Posted by: Guest on November-23-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language