Category: Uncategorized

Cek Tabel yang ada di database postgreSQLSELECT table_nameFROM information_schema.tablesWHERE table_name LIKE ‘%mata%’ OR table_name LIKE ‘%mtk%’ OR table_name LIKE ‘%mk%’AND table_schema = ‘public’; Cek Struktur Tabel yang ada di database postgreSQLSELECT column_name, data_type, is_nullableFROM information_schema.columnsWHERE table_name = ‘m_mata_kuliah’ORDER BY ordinal_position;