Re: Need help with search-and-replace - Mailing list pgsql-sql

From Ian Harding
Subject Re: Need help with search-and-replace
Date
Msg-id 3AF48DB0.295E04FF@pakrat.com
Whole thread Raw
In response to Need help with search-and-replace  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
There are oh-so-many ways, as I am sure people will tell you.  regular
expressions are the most wonderful things for such a task.  I am comfortable
with tcl, so I would read the file into a tcl variable and use 'regsub -all
{\t700:00:00} $instring {} outstring'.

There are unbelievably simple, unvbelievably fast ways to do this in one line
from the shell using sed, but I don't speak sed.  I suspect someone will hook
you up with some basic sed.

Try this in Windows.  Visual Basic can use regular expressions, but you have to
instantiate a regular expression object, then execute one of it's methods to do
anything.  Ugh.

Ian

Josh Berkus wrote:

> Folks,
>
>         I need to strip certain columns out of my pgdump file.  However, I
> can't figure out how to use any Unix-based tool to search-and-replace a
> specific value which includes a tab character (e.g. replace "{TAB}7
> 00:00:00" with "" to eliminate the column).
>
>         RIght now, I'm copying the file to a Win32 machine and using MS Word
> for the search-and-replace, but I'm sure there's got to be a better way
> ... *without* learning VI or Emacs.  Help?
>
>                                         -Josh
>
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@agliodbs.com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster



pgsql-sql by date:

Previous
From: juerg.rietmann@pup.ch
Date:
Subject: calling a function within a view causes problems doing a pg_dumpall
Next
From: "Josh Berkus"
Date:
Subject: Re: calling a function within a view causes problems doing a pg_dumpall