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

From Andreas Joseph Krogh
Subject Execute commands in single-user mode
Date
Msg-id VisenaEmail.50.226f94e7c543b8bd.1522bcb3c7c@tc7-visena
Whole thread Raw
Responses Re: Execute commands in single-user mode
Re: Execute commands in single-user mode
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.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Attachment

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Code of Conduct: Is it time?
Next
From: Melvin Davidson
Date:
Subject: Re: Execute commands in single-user mode