Postgres Pro
Downloads
Home   >   mailing lists

Thread: Table Node Feature

Table Node Feature

From
Mike Surcouf
Date:
I don't know if Im the only one but my tables are always under database ->schema -> public -> tables

It would be nice if I could have tables at the level under database -> tables

Thanks

Mike

Re: Table Node Feature

From
Dave Page
Date:


On Fri, Oct 6, 2017 at 4:06 PM, Mike Surcouf <mikes@surcouf.co.uk> wrote:
I don't know if Im the only one but my tables are always under database ->schema -> public -> tables

It would be nice if I could have tables at the level under database -> tables

That hasn't been possible since PostgreSQL 7.3. Tables are always in a schema now. 


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

RE: Table Node Feature

From
Mike Surcouf
Date:

Hi Dave

 

Yes I understand they have to be in a schema.  I guess I’m asking for a shortcut type of thing.

 

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 06 October 2017 16:27
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: Table Node Feature

 

 

 

On Fri, Oct 6, 2017 at 4:06 PM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

I don't know if Im the only one but my tables are always under database ->schema -> public -> tables

It would be nice if I could have tables at the level under database -> tables

 

That hasn't been possible since PostgreSQL 7.3. Tables are always in a schema now. 

 

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: Table Node Feature

From
Pavel Stehule
Date:


2017-10-06 17:06 GMT+02:00 Mike Surcouf <mikes@surcouf.co.uk>:
I don't know if Im the only one but my tables are always under database ->schema -> public -> tables

It would be nice if I could have tables at the level under database -> tables

it is not practical to have two hierarchies

You don't to use "public" schema explicitly, if you don't want. Schema is just label in Postgres - there is not any related space, there is not any related overhead.

Pavel
 

Thanks

Mike