create_distributed_table can't inherit tablespace

[xieyuheng1025]

create_distributed_table can't inherit tablespace

[Green-Chan]

+1 Is there any way to place shards into a specified tablespace?

[hanefi]

After creating the shards, you can run something like the following:

SELECT *
  FROM run_command_on_shards(
    'my_distributed_table',
    $cmd$
        ALTER TABLE %s SET TABLESPACE new_tablespace
    $cmd$
  );

[xieyuheng1025]

Thank you

[Green-Chan]

Thank you @hanefi , it worked!

[hanefi]

Reopening this issue as I believe this is a valid feature request. Citus can manage tablespaces of shards automatically if the necessary changes are made.