Re: Discussion - Search Objects

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Discussion - Search Objects
Date: 2011-06-01 07:53:46
Message-ID: 1306914826.2070.9.camel@laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

On Wed, 2011-06-01 at 07:50 +0000, Dave Page wrote:
> On Wed, Jun 1, 2011 at 6:06 AM, Guillaume Lelarge
> <guillaume(at)lelarge(dot)info> wrote:
> > On Wed, 2011-06-01 at 01:05 +0200, Jasmin Dizdarevic wrote:
> >> To better get into the code I've decided to implement a feature from
> >> the todo list: "Ability to search a database for objects with a
> >> specific name"
> >> Now I have a first result, which I like to discuss with you.
> >>
> >>
> >> 1. The search is done with this query
> >> select * from (
> >> select 'TABLE' as type, table_name as objectname, table_schema as path
> >> from information_schema.views
> >> union
> >> select 'VIEW' as type, table_name, table_schema from
> >> information_schema.views
> >> union
> >> select 'COLUMN', column_name, table_schema ||'.'||table_name from
> >> information_schema.columns
> >> union
> >> select 'TRIGGER', trigger_name, event_object_schema||'.'||
> >> event_object_table from information_schema.triggers
> >> union
> >> select 'FUNCTION', routine_name, specific_schema from
> >> information_schema.routines
> >> union
> >> select 'SCHEMA', schema_name, '' from information_schema.schemata
> >> union
> >> select 'SEQUENCE', sequence_name, sequence_schema from
> >> information_schema.sequences
> >> union
> >> select 'FSERVER', foreign_server_name, '' from
> >> information_schema.foreign_servers
> >> union
> >> select 'FDW', foreign_data_wrapper_name, '' from
> >> information_schema.foreign_data_wrappers
> >> ) i
> >> where lower(objectname) like '%PATTERN%'
> >> order by 1,2
> >>
> >
> > You miss quite a lot of objects.
>
> Further, we have a general policy of not using information_schema in
> pgAdmin, as users may drop it if they don't need it.
>

One is allowed to drop the information_schema system catalog? I didn't
know that. I guess it's all right 'cause you don't really need it.

> Sorry :-(
>

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2011-06-01 07:59:35 Re: Discussion - Search Objects
Previous Message Dave Page 2011-06-01 07:50:28 Re: Discussion - Search Objects