slavamokerov

/*
  objects_id_object_seq - sequence name
  objects               - table name
  id_object             - ID field name
  seq                   - standard postfix

Doc for setval() and nextval(): https://www.postgresql.org/docs/current/functions-sequence.html
*/

CREATE SEQUENCE IF NOT EXISTS objects_id_object_seq; -- IF NOT EXISTS is works only in Postgres 9.5+

slavamokerov

select
    objoid::regclass as tablename,
    description as field_desc,
    obj_description(objoid::regclass, 'pg_class') as table_desc
from pg_description
where description like 'sometext%'

slavamokerov

{
  "fallback_encoding": "Cyrillic (Windows 1251)",
  "font_face": "JetBrains Mono",
  "font_size": 15,
  "show_encoding": true,
  "tab_size": 2,                     // That's enough.
  "translate_tabs_to_spaces": true,  // So that the gap always means a space.
  "scroll_past_end": true            // On the Mac, this parameter is overwritten, so you have to specify it.
}

slavamokerov

Вводные
Глоссарий
Потребители, потребности
Архитектура
Интеграция
UC Сценарии использования
Сущности
UI Пользовательский интерфейс
API
MQ Очереди