postgresql 9.3

[1/1]

  1. Optimize Your Database: How to Find Large Tables in PostgreSQL
    This code snippet in PostgreSQL (SQL) retrieves information about tables in a database and presents it in a sorted manner based on their total size
  2. Extracting and Matching Values from JSON Arrays in Postgres
    Data Types:PostgreSQL offers two main data types for storing JSON data:json: Stores an exact copy of the input text. Slower for processing but preserves order and whitespace
  3. Example Codes for Modifying JSON Fields in PostgreSQL
    Since PostgreSQL 9.3 doesn't have dedicated JSON manipulation functions, you'll need to work with the JSON data as a string