Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)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