Paweł Domański
18 lines
475 B
SQL
18 lines
475 B
SQL
DATA_DIRECTORY - > Specifies the directory to use for data storage.
|
|
|
|
dbaclass=# show data_directory;
|
|
|
|
data_directory
|
|
-----------------------------
|
|
/Library/PostgreSQL/10/data
|
|
(1 row)
|
|
|
|
dbaclass=# select setting from pg_settings where name = 'data_directory';
|
|
setting
|
|
-----------------------------
|
|
/Library/PostgreSQL/10/data
|
|
(1 row)
|
|
|
|
-- This will show location of important files in postgres
|
|
|
|
dbaclass=# SELECT name, setting FROM pg_settings WHERE category = 'File Locations'; |