Re: cat infile | translate all occurences of "NOT NULL" to ""

From: Webb Sprague <wsprague100(at)yahoo(dot)com>
To: Dan Browning <danb(at)cyclonecomputers(dot)com>, pgsql-novice(at)postgresql(dot)org, redhat-list(at)redhat(dot)com, jsokel(at)mdsi-usa(dot)com
Subject: Re: cat infile | translate all occurences of "NOT NULL" to ""
Date: 2000-09-11 19:38:31
Message-ID: 20000911193831.7947.qmail@web805.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

The easiest thing is probably to use vi. Then write
:s/"NOT NULL"/""/gc
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...

W
--- 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.
>
> Thanks,
>
> Dan Browning
> Network & Database Administrator
> Cyclone Computer Systems
>

__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/

Browse pgsql-novice by date

  From Date Subject
Next Message Eduardo 2000-09-11 20:16:48 Change varchar lenght
Previous Message Stephan Szabo 2000-09-11 16:37:42 Re: Removing all NOT NULL constraints from multiple tables easily