The easiest thing is probably to use vi. Then write
the `g' will do each occurence, and the `c' will ask
for confirmation. Once you are sure everything will
be fine, let it do `all'.
Otherwise, you can use `sed', but that is weird...
--- Dan Browning <danb(at)cyclonecomputers(dot)com> wrote:
> what command do I use to substitute all occurences
> of a certain string (say,
> "NOT NULL") with another arbitrary string, (e.g.
> "")? I've tried grep and
> tr, but can't figure it out.
> Dan Browning
> Network & Database Administrator
> Cyclone Computer Systems
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
pgsql-novice by date
|Next:||From: Eduardo||Date: 2000-09-11 20:16:48|
|Subject: Change varchar lenght|
|Previous:||From: Stephan Szabo||Date: 2000-09-11 16:37:42|
|Subject: Re: Removing all NOT NULL constraints from multiple tables