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

Re: Removing all instances of "NOT NULL" from an entire directory of files

From: ERIC Lawson - x52010 <eric(at)bioeng(dot)washington(dot)edu>
To: Dan Browning <danb(at)cyclonecomputers(dot)com>
Cc: redhat-list(at)redhat(dot)com, pgsql-novice(at)postgresql(dot)org, interchange-users(at)minivend(dot)com
Subject: Re: Removing all instances of "NOT NULL" from an entire directory of files
Date: 2000-09-12 15:26:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
(In tcsh; other shells have similar/equivalent syntax.)

At the shell prompt:

foreach i (*.sql)
echo $i
cp $i $i.bkp

I'm using echo and cp to illustrate the syntax only; your command(s) would
go in their place.

James Eric Lawson
Research Publications Editor III
National Simulation Resource


On Mon, 11 Sep 2000, Dan Browning wrote:

> OK, I've got a command (or two) that will remove all NOT NULL strings from a
> given file.
> 	cat filename | perl -pi -e "s/NOT NULL//g" > filename
> But how do I run that command on every file in a directory, successively?
> (In case you're wondering, I'm working on the pgsql/ directory of .sql files
> that interchange uses to build the database tables).
> Thanks,
> Dan Browning
> Network & Database Administrator
> Cyclone Computer Systems

In response to

pgsql-novice by date

Next:From: Dan BrowningDate: 2000-09-12 23:04:53
Subject: Per-user process limit: ulimit -u unlimited, how to set it for certain users
Previous:From: Oliver ElphickDate: 2000-09-12 13:58:20
Subject: Re: Don't know where to begin

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