Press "Enter" to skip to content

Posts tagged as “PostgreSql”

PostgreSQL – Update data JSON dengan fungsi jsonb_set

0

Contoh query update data JSON : UPDATE NAMA_TABLE SET NAMA_COLUMN=jsonb_set(NAMA_COLUMN, '{NAMA_KEY}', jsonb_set(NAMA_COLUMN->'NAMA_KEY', ?, VALUE_ANDA) , false) RETURNING NAMA_COLUMN   Penjelasan Syntax jsonb_set(target jsonb, path text[], new_value jsonb[, create_missing boolean]) Keterangan…

Alter column di Postgre SQL

0

ALTER TABLE nama_table ALTER COLUMN nama_field TYPE nama_type USING (TRIM(nama_field)::SMALLINT); Related Posts:Belajar TypeScript - Tipe Utilitas

Yii2 – Validation Case Sensitive on PostgreSQL

0

Yii2 – Validation Case Sensitive on PostgreSQL First Insert code below in your Model   public function getUsernameToLower() { return strtolower($this->username); }   and insert code below in rules function…