[GENERAL] Execute commands in single-user mode

[Andreas Joseph Krogh]

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.
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
 <https://www.visena.com>