Execute commands in single-user mode - Mailing list pgsql-general

Hi all.

 

I'm planning to move all my pg_largeobject tables to separate tablespaces and to be able to do that I need to shuddown PG and start in single-user mode, like this:

 

postgres --single -O -D $PGDATA $DB_NAME

 

Then I have to execute the command:

alter table pg_largeobject set tablespace some_tablespace;

 

Is it possible to issue the above ALTER-statement from the command-line so I can start PG in single-user mode AND execute the ALTER-statement from the command-line i a bash-loop?

 

Thanks.