From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html
Date: Wed, 01 Dec 2021 16:14:42 +0100
Message-ID: <0bd53117207a26a5b8dbe03545448e72397c219f.camel@cybertec.at> (raw)
In-Reply-To: <4011114d-e297-bb2e-ab37-9d1b3880b739@jakobs.com>
References: <4011114d-e297-bb2e-ab37-9d1b3880b739@jakobs.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html
In-Reply-To: <0bd53117207a26a5b8dbe03545448e72397c219f.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox