#!/usr/bin/perl -w
use strict;

my $file = "go.txt";

print "\nOpening $file\n";

open(FILE, "< $file") || die "OLD FILE ERROR: Unable to open file: $!\n";
open(OUT, "> $file.new") || die"NEW FILE ERROR: Unable to create new file: $!\n";

my $data=join('',<FILE>);

##</code><code>##

$data =~ s/(CREATE TABLE "SO"\.")([^"]+)(.+?)(PRIMARY KEY)/$1$2$3CONSTRAINT PK_$2 $4/msg;

##</code><code>##

print OUT $data;

print "Closing $file\n";

close(OUT) || die "Unable to close OUT file: $!\n";
close(FILE) || die "Unable to close OLD file: $!\n";