postgres=#
alter database prod_crm set tablespace crm_tblspc;
Before running this. make sure there are no active connections in the database.
You can kill the existing session using below query.

postgres#
select pg_terminate_backend(pid) from pg_stat_activity where datname='DB_NAME';