| 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: | Whole Thread | Raw Message | 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 |