Write a postgre SQL statement to create duplicates of countries table named country_new with all structure and data.
Here in the following is the structure of the table countries.
Column | Type | Modifiers
--------------+-----------------------+-----------
country_id | character varying(2) |
country_name | character varying(40) |
region_id | numeric(10,0) |
Here is the command to see the structure and list of the inserting rows :
postgres=# \d country_new; Column | Type | Modifiers --------------+-----------------------+----------- country_id | character varying(2) | country_name | character varying(40) | region_id | numeric(10,0) | postgres=# SELECT * FROM country_new; country_id | country_name | region_id ------------+--------------+----------- C1 | India | 1002 C2 | USA | (2 rows)need an explanation for this answer? contact us directly to get an explanation for this answer