Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> it seems like we can't do this. At least a get this error:
> db=# alter table pg_largeobject set tablespace otro;
> ERROR: permission denied: "pg_largeobject" is a system catalog
You can move *all* of the system catalogs with ALTER DATABASE SET
TABLESPACE. pg_largeobject might be a special case, but in general
I would think there's no use-case for moving individual catalogs.
regards, tom lane