SQL recipes - The Data Science Notebook

Create copy of a table¶

Oracle

PostgreSQL

CREATE TABLE new_table AS
SELECT * FROM existing_table;