Thread: Knowing how many records I just inserted
Hi.
v7.3.3
INSERT INTO T_LANE_TX
SELECT LANE_TX_ID,
TX_EXTERN_REF_NO,
[snip]
UPDATE_TS,
substring(ACK_DATE from 1 for 8)::date,
FILENAME_ID
FROM T_LANE_TX2
;
INSERT 0 1241897
Ok, I can see that 1,241,897 rows were inserted into T_LANE_TX.
How can I get that back out to bash, if I'm doing psql scripting?
An env. variable wouldn't work, since it would go away when psql
terminates.
TIA
--
+-----------------------------------------------------------------+
| Ron Johnson, Jr. Home: ron.l.johnson@cox.net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+
> How can I get that back out to bash, if I'm doing psql scripting? > An env. variable wouldn't work, since it would go away when psql > terminates. Capture the stdout of the psql command and pipe it through cut in order to get only the third word of output. your_shell_variable=`psql -c 'insert into t1 select attrs from t2' | cut -d' ' -f3` hth, cl. > > TIA > -- > +-----------------------------------------------------------------+ > | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | > | Jefferson, LA USA | > | | > | "I'm not a vegetarian because I love animals, I'm a vegetarian | > | because I hate vegetables!" | > | unknown | > +-----------------------------------------------------------------+ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >