show data_directory;

show all;

SELECT * FROM pg_tablespace;

<POSTGRESQL_DIRECTORY>/data/base/<OID>

ps aux | grep postgres | grep -- -D

CREATE TABLESPACE dbspace LOCATION '/data/dbs';
CREATE TABLE something (......) TABLESPACE dbspace;
CREATE TABLE otherthing (......) TABLESPACE dbspace;

SELECT oid from pg_database WHERE datname = <database_name>;

SELECT relname, relfilenode FROM pg_class WHERE relname = <table_name>;

PG_VERSION      pg_dynshmem     pg_multixact
pg_snapshots    pg_tblspc       postgresql.conf
base            pg_hba.conf     pg_notify
pg_stat         pg_twophase     postmaster.opts
global          pg_ident.conf   pg_replslot
pg_stat_tmp     pg_xlog         postmaster.pid
pg_clog         pg_logical      pg_serial
pg_subtrans     postgresql.auto.conf    server.log

pg_ctl -D /usr/local/var/postgres -w start