PostgreSQL: Getting service uptime

• SQL
• 0
• 1
• 2025

Oracle: paging results.

• SQL
• 2
• 3
• 2265

PostgreSQL: Enlarge varchar field size without changing data.

• SQL
• 0
• 0
• 1708

Postgresql: Create dblink

• SQL
• 0
• 2
• 1355

PostgreSQL: Extract function DDL

• SQL
• 0
• 0
• 1774

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

• SQL
• 0
• 0
• 1019

Postgresql: Trigger template

• SQL
• 0
• 0
• 966

Postgres: Filter using ilike and string with spaces

• SQL
• 0
• 0
• 1382

Postgres: Get string all matches between {}

• SQL
• 0
• 0
• 672

Postgresql: Must know

• SQL
• 0
• 0
• 725

PostgreSQL: Extremely fast text search using tsvector

• SQL
• 0
• 0
• 1176

PostgreSQL: Create a copy of DB in same host

• SQL
• 0
• 0
• 584

PostgreSQL: Set search path (schemas) for user

• SQL
• 0
• 0
• 528

Firebird/SQL: Find holes in a sequence

• SQL
• 0
• 0
• 648

Firebird: Create an Array of integers from String

• SQL
• 0
• 0
• 1092

Firebird: Create Array from CSV String

• SQL
• 0
• 0
• 559

Oracle: Create/drop tablespace

• SQL
• 0
• 0
• 560

Oracle: Get slow queries

• SQL
• 0
• 0
• 378

Firebird: Age Calculation to Ymd

• SQL
• 0
• 0
• 495

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

• SQL
• 0
• 0
• 271