Re: What is the benefit of schemas? - Mailing list pgsql-general

From Mikael Carneholm
Subject Re: What is the benefit of schemas?
Date
Msg-id 1044302804007375@lycos-europe.com
Whole thread Raw
In response to What is the benefit of schemas?  ("Berend Tober" <btober@computer.org>)
List pgsql-general
Pre-7.3 schemas:

\c appfoo appfoouser
select customerID
from appfootable
where appfootable.barcolumn = 'some value';

\c customers customersuser
select *
from customer
where ID = customerID;

Post-7.3 schemas:

\c companydb companydbuser
select c.*
from customers.customer c, appfoo.appfootable a
where a.barcolumn = 'some value' and a.customerID = c.ID;

'nough said? :)

_____________________________________________________________
Här börjar internet!
Skaffa gratis e-mail och gratis internet på http://www.spray.se

Träffa folk från hela Sverige på ett och samma ställe - http://chat.spray.se/



pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: 335 times faster (!)
Next
From: Mikael Carneholm
Date:
Subject: Re: 335 times faster (!)