- PostgreSQL
- SQL
- Databases
- Query Syntax
Join multiple sql in postgresql
I have below 3 sql but I need 1 sql that can show all 3 result as 1 output
Sql : select current_database();
Output : dbname
Sql : select inet_server_addr();
Output : 101.99.234.20
Sql : select user;
Output : userA
Above is 3 different output but I need 1 sql that can give 1 output like below.
Output
Current_database,ip,user
Dbname, 101.99.234.20, userA
Is it possible to join these sql.
Sql : select current_database();
Output : dbname
Sql : select inet_server_addr();
Output : 101.99.234.20
Sql : select user;
Output : userA
Above is 3 different output but I need 1 sql that can give 1 output like below.
Output
Current_database,ip,user
Dbname, 101.99.234.20, userA
Is it possible to join these sql.
