Postgres Update & View config directly via SQL

Postgres Config

-- Show current settings...
show config_file
show max_connections
show log_min_duration_statement
show log_directory 
show data_directory

-- more detailed info on current settings...
select * from pg_settings where name='max_connections';

-- update setting via sql
ALTER SYSTEM SET max_connections = 202;
ALTER SYSTEM SET log_min_duration_statement = '200'

-- reload settings... only apples to settings that support hot reload...
select pg_reload_conf()