Saturday, September 29, 2012

Inspecting your postgreSQL connection information

If you want to confirm you've connected to the right place and in the right way, you can execute some or all of the following commands:

SELECT inet_server_port();  
SELECT current_database();  
SELECT current_user;  
SELECT inet_server_addr();  
SELECT version();

No comments:

Post a Comment

Oracle Query