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

From: Haroldo Stenger <haroldo(dot)stenger(at)gmail(dot)com>
To: raghavendrajsv(at)gmail(dot)com
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to search particular line/text code in all Postgres all database object's
Date: 2018-08-28 07:49:09
Message-ID: CAEse+z_dep5F61uLZROjF7Xh38-Hj0JJZmoUuXN7zO9Y8SeTog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dean Rasheed 2018-08-28 08:42:51 Re: Will there ever be support for Row Level Security on Materialized Views?
Previous Message rob stone 2018-08-28 07:45:14 Re: Which background task looks for pg_xlog in 10?