2016-06-09 13:15 GMT+12:00 John R Pierce <pie...@hogranch.com>: > On 6/8/2016 5:46 PM, Patrick B wrote: > > Single id as you show, a range of numbers or an array of numbers? > > > select function(21); > > Where 21 = Number of ids > > > how do you get the specific ID's from "21" ? > > > 21 is the number of IDS that I wanna perform that COPY command....
twenty one times this sql: COPY > COPY > (SELECT * FROM backup_table WHERE id = 1112 AND status = 1) > TO '/var/lib/pgsql/1112.sql'; > COPY > (SELECT * FROM backup_table WHERE id = 1113 AND status = 1) > TO '/var/lib/pgsql/1113.sql';
