Author: admin

syntax COPY FROM <schema>/<password>@<database> TO <schema>/<password>@<database> CREATE | REPLACE | INSERT | APPEND <tablename> USING <Select clause that returns a results set> example COPY FROM one-schema/one-schemas-password@one-database TO another-schema/another-schemas-password@another-database> CREATE replica-table USING SELECT * FROM original-table   Good idea to create …

Copy Table – more powerful Read more »

syntax CREATE TABLE AS SELECT FROM example CREATE TABLE new_cusomer AS SELECT * FROM customer