Write a postgre SQL statement to change the name of the column state_province to state, keeping the same size and data type and size.
Here is the structure of the table locations.
postgres=# \d locations
Column | Type | Modifiers
----------------+-----------------------+-----------
location_id | numeric(4,0) |
street_address | character varying(40) |
postal_code | character varying(12) |
city | character varying(30) |
state_province | character varying(25) |
country_id | character varying(2) |
region_id | text |
Output:
Now see the structure of the table locations after alteration.
need an explanation for this answer? contact us directly to get an explanation for this answer