Thread: New functionality - Table tree view

Hi,

It's been a while I think a possibility of tree view for table will be a great improvment for pgadmin.

It's possible to consider "tree view" in differents way
- Possibility to create virtual directories for tables and possibility to expand or not expand these directories
- Possibilty to group table by a prefix/suffix/regexp of tables names
- Possibility to group herited tables
- other possibilities...

When we have hundreds table, it will be a great help. And I think with a little imagination we should be able to find a
solution

Thanks.

On Thu, 2014-03-13 at 15:25 +0530, Ashesh Vashi wrote:
> I think - that's where schema helps.
>

Yeah, but I don't think that's what the OP wants. Which won't happen any
time soon.

>
> On Thu, Mar 13, 2014 at 3:19 PM, <benj.dev@laposte.net> wrote:
>
> > Hi,
> >
> > It's been a while I think a possibility of tree view for table will be a
> > great improvment for pgadmin.
> >
> > It's possible to consider "tree view" in differents way
> > - Possibility to create virtual directories for tables and possibility to
> > expand or not expand these directories
> > - Possibilty to group table by a prefix/suffix/regexp of tables names
> > - Possibility to group herited tables
> > - other possibilities...
> >
> > When we have hundreds table, it will be a great help. And I think with a
> > little imagination we should be able to find a solution
> >
> > Thanks.
> >
> >
> > --
> > Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgadmin-hackers
> >
>
>
>


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

Thanks for reply,

Ok schema can help (I currently use it to "hide" many herited table).
But sometimes I would like to have an overview of my tables, functions
or others objects and if I have to much object it's "difficult" to
apprehend, so my first idea was to arrange that in a tree view.
There is an intermediary level (objects) and it's generate "visual
pollution" and sometimes difficulty to navigate.

With more thinking (thanks to you), maybe a more simple idea will be an
option to put "schemas" a level down (invert object and schema)

To try to better understand me :
Currently we have :
+ Database
 + basename
   + Catalogues
   + Extensions
   + Schemas
     + public
       + Collationnements
       + Functions
       + Tables
       + Types
       + View
       + ...
     + myprivateschema1
       + ...
     + myprivateschema2
       + ...

The idea is an option which allow to obtain :
+ Database
 + basename
   + Catalogues
   + Extensions
   + "NameToInvent"
     + Collationnements
       + public
       + myprivateschema1
       + myprivateschema2
     + Functions
       + public
       + myprivateschema1
       + myprivateschema2
     + Tables
       + public
       + myprivateschema1
       + myprivateschema2
     + Types
       + public
       + myprivateschema1
       + myprivateschema2
     + View
       + public
       + myprivateschema1
       + myprivateschema2
     + ...

Regards

Le 13/03/2014 10:55, Ashesh Vashi a écrit :
> I think - that's where schema helps.
>
>
> On Thu, Mar 13, 2014 at 3:19 PM, <benj.dev@laposte.net
> <mailto:benj.dev@laposte.net>> wrote:
>
>     Hi,
>
>     It's been a while I think a possibility of tree view for table will
>     be a great improvment for pgadmin.
>
>     It's possible to consider "tree view" in differents way
>     - Possibility to create virtual directories for tables and
>     possibility to expand or not expand these directories
>     - Possibilty to group table by a prefix/suffix/regexp of tables names
>     - Possibility to group herited tables
>     - other possibilities...
>
>     When we have hundreds table, it will be a great help. And I think
>     with a little imagination we should be able to find a solution
>
>     Thanks.
>
>
>     --
>     Sent via pgadmin-hackers mailing list
>     (pgadmin-hackers@postgresql.org <mailto:pgadmin-hackers@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgadmin-hackers
>
>
>
>
> --
> --
>
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA: Enterprise PostgreSQL Company
> <http://www.enterprisedb.com>
>
>
>
> /http://www.linkedin.com/in/asheshvashi/
>