From: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | postgres insert + select + values - Pgsql 9.5 |
Date: | 2016-09-15 21:45:37 |
Message-ID: | CAJNY3isEDP0WvpPw3wjPpqM=Qb_HbLkNs0vc48tr2qvJUbpTnQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi guys,
I got the test1 table with three columns:
id(BIGINT) - j_id(BIGINT) - comments(CHARACTER VARYING)
*This needs to be done 180 times:*
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123321,'test-1 -
> comments');
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123322,'test-1 -
> comments');
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123323,'test-1 -
> comments');
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123324,'test-1 -
> comments');
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123325,'test-1 -
> comments');
*However, I have to get j_id from another table:*
> select j_id from test2 WHERE customer_id = 88897
17012651
> 17012601
> 16623374
> 16808986
> 16843879
> 16808794
> 16870199
> 16870488
> 16870443
> 16870403
*Example of what I need:*
INSERT INTO test1 (id,j_id,comments) VALUES (default, 17012651,'test-1 -
> comments');
> INSERT INTO test1 (id,j_id,comments) VALUES (default, 17012601,'test-1 -
> comments');
> INSERT INTO test1 (id,j_id,comments) VALUES (default, 16623374,'test-1 -
> comments');
> INSERT INTO test1 (id,j_id,comments) VALUES (default, 16808986,'test-1 -
> comments');
> INSERT INTO test1 (id,j_id,comments) VALUES (default, 16843879,'test-1 -
> comments');
etc...
How can I do that? If the customer_id is the same for all those 180 rows?
Cheers
Patrick
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Mead | 2016-09-15 21:58:04 | Re: Unable to create oracle_fdw (foreign data wrapper) extension |
Previous Message | Arun Rangarajan | 2016-09-15 20:57:52 | Re: Unable to create oracle_fdw (foreign data wrapper) extension |