[prev] 43 [next]

Exercise 7: PostgreSQL Data Files

PostgreSQL uses OIDs as
  • the name of the directory for each database
  • the name of the files for each table
Using the pg_catalog tables, find ..
  • the directory for the database
  • the data files for the Pizzas and People tables
Relevant catalog info ... 

pg_database(oid,datname,...)
pg_class(oid,relname,...)