Sql

SELECT current_database();

-- Query to get all database in PostgreSQL and their oid (alternative to l) 
SELECT oid, datname FROM pg_database;

# List databases:
l

List all databases:
l

SELECT datname FROM pg_database;

# inside psql
l

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

l OR l+

l
Code language: Shell Session (shell)

postgres=# l+
Code language: psql

PREVIOUS	NEXT

Code Example
Sql :: oracle sql select all days between two dates except weekends
Sql :: mysql ip address data type
Sql :: create temporal table in sql
Sql :: sqlite autoincrement
Sql :: oracle log files
Sql :: sql server insert into select
Sql :: python pandas df to postgres json table
Sql :: sql select most frequent value in column
Sql :: select milliseconds mysql
Sql :: sql select duplicates based on two columns
Sql :: update with select postgresql
Sql :: update with join
Sql :: spring data.sql table not found
Sql :: copy value from one column to another postgres
Sql :: sum query in sql
Sql :: mysql 1 hour ago
Sql :: mysql cast null to string
Sql :: mysql check date range
Sql :: mariadb json_extract
Sql :: csv into data postgres
Sql :: sql create database
Sql :: activate log mysql
Sql :: how to check table name in current database sql
Sql :: current date in sql
Sql :: mysql order by multiple columns
Sql :: default number in sql
Sql :: oracle duration between timestamps
Sql :: sql database connectivity
Sql :: sub query in linq
Sql :: SQL Duplicates by Composite