Re: Regex help again (sorry, I am bad at these)

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Mon, Dec 28, 2015 at 12:25 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:

Will this work?

UPDATE your_table
   SET your_column = REPLACE (your_column, 'HVACR1114_LAB_13A.pdf', '&file=HVACR1114_LAB_13A.pdf')
 WHERE <whatever_expression is needed>;

Your mileage may vary because you have not stated your VERSION of PostgreSQL or your O/S.

​What part of your solution is version or O/S dependent?

David J.

​