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

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html
Date: 2021-12-01 14:37:06
Message-ID: 4011114d-e297-bb2e-ab37-9d1b3880b739@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

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).

--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2021-12-01 15:14:42 Re: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html
Previous Message Edward J. Sabol 2021-11-29 18:28:20 Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.