Thread: postgres scripting

Hi all,

I have to reindex 2 indexes in pg_catalog using postgres --single.
There are 16 seperate databases on each of 4 servers that I have to do
this on, so obviously it would be much better to script the changes.  I
can handle identifying the dbs and starting postgres no problem, but I
can't seem to find a way to pass a CTRL-D character from within a bash
script to the postgres executable.

Has anyone done anything like this?  Any suggestions? I am running
postgres 3.1.1.8 on Solaris 5.10.

Thanks!

John


John P Weatherman
Sr DBA
Asurion, Inc.

John P Weatherman <jweatherman91@alumni.wfu.edu> wrote:

> can handle identifying the dbs and starting postgres no problem, but
I
> can't seem to find a way to pass a CTRL-D character from within a
bash
> script to the postgres executable.

Why not put the SQL in a separate file and pipe it in?
(I haven't tested that, but it seems likely to work....)

-Kevin

John P Weatherman <jweatherman91@alumni.wfu.edu> writes:
> I can't seem to find a way to pass a CTRL-D character from within a bash
> script to the postgres executable.

Control-D is just a way to signal EOF from the keyboard.  If you're
scripting, reaching the end of the script input does the same thing.

            regards, tom lane