Re: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Holger Jakobs <holger(at)jakobs(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html
Date: 2021-12-01 15:14:42
Message-ID: 0bd53117207a26a5b8dbe03545448e72397c219f.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2021-12-01 15:44:35 Re: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html
Previous Message Holger Jakobs 2021-12-01 14:37:06 Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html