Postgres Pro
Downloads
Home   >   mailing lists

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

From Holger Jakobs
Subject Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html
Date
Msg-id 4011114d-e297-bb2e-ab37-9d1b3880b739@jakobs.com
Whole thread Raw
Responses Re: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view 
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
Attachment

pgsql-admin by date:

Previous
From: "Edward J. Sabol"
Date:
Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
Next
From: Laurenz Albe
Date:
Subject: Re: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html