PostgreSQL SQL: Difference between revisions
Created page with "Copy table, but not an exact copy, e.g. indexes not copied <pre> CREATE TABLE new_tab_name AS TABLE existing_tab_name </pre>" |
No edit summary |
||
| Line 1: | Line 1: | ||
Copy table, but not an exact copy, e.g. indexes not copied | Copy table, but not an exact copy, some settings changed and e.g. indexes not copied | ||
<pre> | <pre> | ||
CREATE TABLE new_tab_name AS TABLE existing_tab_name | CREATE TABLE new_tab_name AS TABLE existing_tab_name | ||
</pre> | </pre> | ||
Latest revision as of 2023-04-04T19:11:25
Copy table, but not an exact copy, some settings changed and e.g. indexes not copied
CREATE TABLE new_tab_name AS TABLE existing_tab_name