Write a postgre SQL statement to insert a record with your own value into the table countries against each column

hamza

Save to bookmark

2022-05-18

121

Write a postgre SQL statement to insert a record with your own value into the table countries against each column.

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)         |

Postgre SQL,

All Answers

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

INSERT INTO countries VALUES('C1','India',1002);

Here is the command to see the list of inserting rows:

postgres=# SELECT * FROM countries;
 country_id | country_name | region_id
------------+--------------+-----------
 C1         | India        |      1002
(1 row)

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Write a postgre SQL statement to insert a record with your own value into the table countries against each column

All Answers

Similar questions

need a help?

find thousands of online teachers now