Postgres Pro
Downloads
Home   >   mailing lists

Re: How to search particular line/text code in all Postgres alldatabase object's - Mailing list pgsql-general

From Haroldo Stenger
Subject Re: How to search particular line/text code in all Postgres alldatabase object's
Date
Msg-id CAEse+z_dep5F61uLZROjF7Xh38-Hj0JJZmoUuXN7zO9Y8SeTog@mail.gmail.com
Whole thread Raw
In response to How to search particular line/text code in all Postgres all database object's  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: rob stone
Date:
Subject: Re: Which background task looks for pg_xlog in 10?
Next
From: Dean Rasheed
Date:
Subject: Re: Will there ever be support for Row Level Security on Materialized Views?