Improve psql \d output

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Improve psql \d output
Дата
Msg-id 01c201c2f1be$185fffa0$6500a8c0@fhp.internal
обсуждение исходный текст
Ответы Re: Improve psql \d output  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Improve psql \d output  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
Example:

test=# \d test
     Table "public.test"
 Column |  Type   | Modifiers
--------+---------+-----------
 a      | integer | not null
Indexes:
    "test_pkey" PRIMARY KEY btree (a)
Check Constraints:
    "$2" CHECK (a > 1)
Foreign Key Constraints:
    "$1" FOREIGN KEY (a) REFERENCES parent(b)
Rules:
    myrule AS ON INSERT TO test DO INSTEAD NOTHING
Triggers:
    "asdf asdf" AFTER INSERT OR DELETE ON test FOR EACH STATEMENT EXECUTE
PROCEDURE update_pg_pwd_and_pg_group(),
    mytrigger AFTER INSERT OR DELETE ON test FOR EACH ROW EXECUTE PROCEDURE
update_pg_pwd_and_pg_group()

I have minimised the double quoting of identifiers as much as I could
easily, and I will submit another patch when I have time to work on it that
will use a 'fmtId' function to determine it exactly.

I think it's a significant improvement in legibility...

Obviously the table example above is slightly degenerate in that not many
tables in production have heaps of (non-constraint) triggers and rules.

Chris

Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: holdable cursors
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Doc patch for func.sgml (resend)