[HACKERS] COPY TABLE TO

Hi, I need to write a tab separated text file such that the first row contains number of records in the table. I insert first row with '0' (zero) as first column & rest columns NULL. Then at the end of writing records to table I do a select into Variable count(*) from table. & update the first rec

[HACKERS] plpgsql Integer Concat To String

Hi, I want to concatenate a it counter to a string in a loop in plpgsql. DECLARE counter integer := 1; IdSet char : = 'UniqueId' IdForEachRun varchar; BEGIN IdForEachRun := IdSet || counter;(PROBLEM HERE) --Or IdForEachRun := IdSet + counter;(PROBLEM HERE) While condition LOOP Insert into Table