Обсуждение: Identifying ALTER TABLE "sub-command"

Поиск

Список

Период

Сортировка

Identifying ALTER TABLE "sub-command"

От

Jeremy Finzel

Дата:

11 января 2018 г., 18:56:32

Hello -

I have found that in leveraging the parser code to decode DDL SQL, it is very easy to get which type of general command is being issued with CreateCommandTag(parsetree). However, is there a way (or a starting point) to identify the sub-command as well i.e. ENABLE TRIGGER, ADD FOREIGN KEY, etc.?

Any direction is much appreciated.

Thanks,

Jeremy

Re: Identifying ALTER TABLE "sub-command"

От

Alvaro Herrera

Дата:

11 января 2018 г., 19:25:22

Jeremy Finzel wrote:
> Hello -
> 
> I have found that in leveraging the parser code to decode DDL SQL, it is
> very easy to get which type of general command is being issued with
> CreateCommandTag(parsetree).  However, is there a way (or a starting point)
> to identify the sub-command as well i.e. ENABLE TRIGGER, ADD FOREIGN KEY,
> etc.?

Hi Jeremy,

See the test code in src/test/modules/test_ddl_deparse/test_ddl_deparse.c
It might give you some ideas.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Identifying ALTER TABLE "sub-command"

Identifying ALTER TABLE "sub-command"

Re: Identifying ALTER TABLE "sub-command"