Re: How to search particular line/text code in all Postgres alldatabase object's

Поиск
Список
Период
Сортировка
От Haroldo Stenger
Тема Re: How to search particular line/text code in all Postgres alldatabase object's
Дата
Msg-id CAEse+z_dep5F61uLZROjF7Xh38-Hj0JJZmoUuXN7zO9Y8SeTog@mail.gmail.com
обсуждение исходный текст
Ответ на How to search particular line/text code in all Postgres all database object's  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
Список pgsql-general
Дерево обсуждения
why not dump them and grep inside?

a command like this should help
pg_dump -h localhost -U username -Fc -s -f db_dump dbName

El lun., 27 de ago. de 2018 a la(s) 23:27, Raghavendra Rao J S V (raghavendrajsv@gmail.com) escribió:
Hi All,

How to search particular line/text code in all Postgres all database object's like functions,triggers,views etc ?

Is there any data dictionary table in Postgres?

Eg:- My requirement is , I want to found data related to employee table in any function, trigger,view etc.

Kindly help me.
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425

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

Предыдущее
От: rob stone
Дата:
Сообщение: Re: Which background task looks for pg_xlog in 10?
Следующее
От: Dean Rasheed
Дата:
Сообщение: Re: Will there ever be support for Row Level Security on Materialized Views?