Re: Search Objects - redux

[Melvin Davidson]

Stefan,
I am not PgAdmin support, but I've attached a bash script and sql query that 
may helpin searching for column names. 

Melvin Davidson 🎸
 I reserve the right to fantasize.  Whether or not you 
 wish to share my fantasy is entirely up to you. 
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day 
www.folkalley.com

 

    On Monday, January 22, 2018, 10:05:54 AM EST, Dave Page <dp...@pgadmin.org> 
wrote:  
 
 Hi

On Mon, Jan 22, 2018 at 2:51 PM, Stefan Zauchenberger <ste...@ice-sys.com> 
wrote:


I will see about recruiting one of my comrades (more qualified) to work on the 
feature.


Cool, thanks! 

 

 

Is it safe to use a version of pgadmin3 to search dbs in the meantime?


It's safe, but I don't know whether it'll work. It should be obvious if not. 
  

tables_with_column_name.sh
Description: Binary data

SELECT c.table_schema as schema,
       c.table_name as table, 
       c.column_name as column, 
       c.data_type as type,
       case when c.data_type LIKE '%char%'
              then COALESCE(character_maximum_length::text, 'N/A')
            when c.data_type LIKE '%numeric%'
              then  '(' || c.numeric_precision::text || ', ' || 
c.numeric_scale::text || ')'
            when c.data_type LIKE '%int%'
              then  c.numeric_precision::text
         else COALESCE(character_maximum_length::text, 'N/A')
       end as size
  FROM information_schema.columns c
WHERE c.table_schema NOT LIKE 'pg_%' 
  AND c.table_schema NOT LIKE 'information%' 
  AND c.table_name NOT LIKE 'sql_%' 
  AND c.is_updatable = 'YES'
  AND c.column_name LIKE '%<COLUMN_NAME>%'
ORDER BY c.table_name, c.column_name;