Message-ID: <0bd53117207a26a5b8dbe03545448e72397c219f.camel@cybertec.at>
Subject: Re: Suggestion: Explain how to move objects to the default
 tablespace in sql-altertable.html
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Holger Jakobs <holger@jakobs.com>, "pgsql-admin@lists.postgresql.org"
	 <pgsql-admin@lists.postgresql.org>
Date: Wed, 01 Dec 2021 16:14:42 +0100
In-Reply-To: <4011114d-e297-bb2e-ab37-9d1b3880b739@jakobs.com>
References: <4011114d-e297-bb2e-ab37-9d1b3880b739@jakobs.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/0bd53117207a26a5b8dbe03545448e72397c219f.camel%40cybertec.at>
Precedence: bulk

On Wed, 2021-12-01 at 15:37 +0100, Holger Jakobs wrote:
> Today I wanted to move an object to the unnamed defaul tablespace. It 
> took me a while to find out that neither the empty string '' nor the 
> word default works, but that you have to use pg_default.
> 
> This should be mentioned in the documentation of the ALTER TABLE command 
> (and maybe others).

Not sure if that is necessary.  You have to use the name of the tablespace.
You can see that with "\db" in psql or query "pg_tablespace".

That's no different from other tablespaces...

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com