Skip to content

Instantly share code, notes, and snippets.

@cubespace

cubespace/sql, postgres, psql

Forked from igorpronin/sql, postgres, psql
Created May 30, 2017 08:57
Show Gist options
  • Save cubespace/eb18a008701ffc9b15321dc368087928 to your computer and use it in GitHub Desktop.
Save cubespace/eb18a008701ffc9b15321dc368087928 to your computer and use it in GitHub Desktop.
Download ZIP
Копировать структуру таблицы
Raw
sql, postgres, psql
CREATE TABLE table2 AS SELECT * FROM table1 WHERE 1=2;
(This creates the structure only -- no data will be transferred because
1 will never equal 2). :)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment