PostgreSQL| Lec-16 | Tablespaces
In this video we will see:
What are tablespaces, why we need them?
How to create a tablespace?
How to create a database?
How to create a table with tablespace?
How to query the databases to find the tablespaces for databases?
-- To move table from one tablespace to another tablespace
alter table "tablename" set tablespace "tablespacename";
--here ''" not required in original query.
You will get all the required information about the tablespaces in this video.