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

Поиск
Список
Период
Сортировка
От Webb Sprague
Тема Re: cat infile | translate all occurences of "NOT NULL" to ""
Дата
Msg-id 20000911193831.7947.qmail@web805.mail.yahoo.com
обсуждение исходный текст
Ответ на cat infile | translate all occurences of "NOT NULL" to ""  ("Dan Browning" <danb@cyclonecomputers.com>)
Список 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@cyclonecomputers.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/

В списке pgsql-novice по дате отправления:

Предыдущее
От: patrick.wolf@Aerojet.com (WOLF, PATRICK)
Дата:
Сообщение: RE: Removing all NOT NULL constraints from multiple tabl es easily
Следующее
От: Eduardo
Дата:
Сообщение: Change varchar lenght