Different sub Directories in a database

[shijosp7]

Hi All,

Can we create sub directories in a database with same tables. I need to create yearly wise sub directory and store the yearly wise data in different directories. Is it possible in postgreSQL ?

Thank You

Shijo S Philip

[Oralloy]

Shijo,

Use tablespaces.

ref: PostgreSQL Documentation 9.5: CREATE TABLESPACE

Cheers!
Oralloy