view postgres port code example Example: how to check port number for postgresql SELECT * FROM pg_settings WHERE name = 'port';