Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql show current database

SELECT current_database();
Comment

postgres show databases

# List databases:
l
Comment

postgres show databases

SELECT datname FROM pg_database;
Comment

postgres show databases

# inside psql
l
Comment

psql show db

SELECT datname FROM pg_database;
Code language: SQL (Structured Query Language) (sql)
Comment

show all databases postgres

l
Code language: Shell Session (shell)
Comment

psql view databases

postgres=# l+
Code language: psql
Comment

PREVIOUS NEXT
Code Example
Sql :: select row with latest date mysql 
Sql :: insert value to new table by joining 2 different tables 
Sql :: sql update from one table to another based on a id match 
Sql :: mysql insert into multiple tables 
Sql :: query on date sqlite flutter 
Sql :: sql server port number 
Sql :: connect mysql 
Sql :: TSQL convert csv to table 
Sql :: union sql 
Sql :: quit mysql 
Sql :: select sql 
Sql :: oracle select into and inner join 
Sql :: call rest api from postgresql 
Sql :: subquery sql 
Sql :: mariadb 
Sql :: sql select condition with left join 
Sql :: sql online code 
Sql :: 10000000000000000000 am to meters 
Sql :: postgres type equivalent to timespan c# 
Sql :: fonction stockée sql*plus 
Sql :: naming conventions postgres index 
Sql :: datetrunc hour snowflake 
Sql :: como leer datos de mysql esp32 
Sql :: how to innjert in other database 
Sql :: select multiple columns count one column and group by one column in one table 
Sql :: sqlite schema structure of a relational database 
Sql :: query for backup a database at another location in file system 
Sql :: não é possível executar uma operação DML dentro de uma consulta 
Sql :: SQL random boolean 
Sql :: systemverilog unique constraint unique values 
ADD CONTENT
Topic
Content
Source link
Name
9+9 =