in reply to Re: Re: Regular Expression Problem
in thread Regular Expression Problem

s/(PRIMARY KEY\([^)]\))/CONSTRAINT PK_$table $1 USING INDEX TABLESPACE + INDEXES/;
as long as you have the primary key columns defined within brackets after "PRIMARY KEY".

rdfield