Skip site navigation (1) Skip section navigation (2)

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

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Tamsin <tg_mail(at)bryncadfan(dot)co(dot)uk>
Cc: Dan Browning <danb(at)cyclonecomputers(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: RE: cat infile | translate all occurences of "NOT NULL" to ""
Date: 2000-09-11 14:53:31
Message-ID: Pine.BSF.4.21.0009111153090.1305-100000@thelab.hub.org (view raw or flat)
Thread:
Lists: pgsql-novice
cat infile | sed 's/NOT NULL//g' 

should do it as well ...

On Mon, 11 Sep 2000, Tamsin wrote:

> in vi you can type : and then 1,$s/oldstring/newstring/g
> where 1 means start from the first line, $ means until the end of the file,
> oldstring is what you want to replace, newstring is what you want to replace
> it with, and the g means do it globally throughout the file.
> 
> e.g.	1,$s/NOT NULL//g 	should work
> 
> Hope this helps
> Tamsin
> 
> -----Original Message-----
> From: pgsql-novice-owner(at)hub(dot)org [mailto:pgsql-novice-owner(at)hub(dot)org]On
> Behalf Of Dan Browning
> Sent: 11 September 2000 15:16
> To: pgsql-novice(at)postgresql(dot)org; redhat-list(at)redhat(dot)com;
> jsokel(at)mdsi-usa(dot)com
> Subject: [NOVICE] cat infile | translate all occurences of "NOT NULL" to
> ""
> 
> 
> 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
> 
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org 


In response to

pgsql-novice by date

Next:From: WOLF, PATRICKDate: 2000-09-11 15:13:29
Subject: RE: Removing all NOT NULL constraints from multiple tabl es easily
Previous:From: Jochen WeyermannsDate: 2000-09-11 14:48:57
Subject: Re: cat infile | translate all occurences of "NOT NULL" to ""

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group