Insert using condition postgres

WITH get_cust_code_for_cust_id AS (
    SELECT cust_code FROM cust WHERE cust_id=11
)

INSERT INTO public.table_1(
    cust_code, issue, status, created_on)
    VALUES (SELECT cust_code FROM get_cust_code_for_cust_id, 'New Issue', 'Open', current_timestamp)

Source: stackoverflow.com

Similar codes

0 vote374 views2 answers
How to get max from each department in sql
SQL
19 votes353 views3 answers
Grant mysql
SQL
0 vote333 views1 answer
How to check xampp mysql password
SQL
0 vote339 views1 answer
Sql server list user permissions
SQL
14 votes359 views2 answers
Oracle limit rows
SQL
0 vote370 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote366 views3 answers
CONTACT FORM SQL
SQL
0 vote363 views1 answer
Postgresql like
SQL
27 votes351 views6 answers
Set password mysql
SQL
0 vote337 views1 answer
Get employees if not contains in sql
SQL