PostgreSQL: Getting service uptime

• SQL
• 0
• 1
• 2344

Oracle: paging results.

• SQL
• 2
• 3
• 2718

PostgreSQL: Enlarge varchar field size without changing data.

• SQL
• 0
• 0
• 1996

Postgresql: Create dblink

• SQL
• 0
• 2
• 1626

PostgreSQL: Extract function DDL

• SQL
• 0
• 0
• 2440

PostgreSQL: Backup/Restore database from/to postgres docker.

• SQL
• 0
• 0
• 1374

Postgresql: Trigger template

• SQL
• 0
• 0
• 1381

Postgres: Filter using ilike and string with spaces

• SQL
• 0
• 0
• 2133

Postgres: Get string all matches between {}

• SQL
• 0
• 0
• 887

Postgresql: Must know

• SQL
• 0
• 0
• 965

PostgreSQL: Extremely fast text search using tsvector

• SQL
• 0
• 0
• 1685

PostgreSQL: Create a copy of DB in same host

• SQL
• 0
• 0
• 802

PostgreSQL: Set search path (schemas) for user

• SQL
• 0
• 0
• 798

Firebird/SQL: Find holes in a sequence

• SQL
• 0
• 0
• 944

Firebird: Create an Array of integers from String

• SQL
• 3
• 0
• 1625

Firebird: Create Array from CSV String

• SQL
• 0
• 0
• 846

Oracle: Create/drop tablespace

• SQL
• 0
• 0
• 818

Oracle: Get slow queries

• SQL
• 0
• 0
• 622

Firebird: Age Calculation to Ymd

• SQL
• 0
• 0
• 997

FirebirdSQL: Create Range of dates, fraction in days, hours, minutes, months or years

• SQL
• 0
• 0
• 569