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
