BTW, it's always good form to state the exact O/S and version of PostgreSQL, regardless of whether you think it may apply.
On Sun, Jan 10, 2016 at 8:53 AM, Andreas Joseph Krogh <andreas@visena.com> wrote:
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?