schema or catalog? what's the diference?

From: Angel Alvarez <clist(at)uah(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: schema or catalog? what's the diference?
Date: 2008-12-11 13:54:11
Message-ID: 200812111454.11970.clist@uah.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

pgagent.sql creates a new schema for pgagent stuff but it shows it as catalog

whats the diference? as it seems they are created almost equal..

for pgagent 'catalog'

CREATE SCHEMA pgagent
AUTHORIZATION postgres;
COMMENT ON CATALOG pgagent IS 'pgAgent system tables';

for public schema

REATE SCHEMA public
AUTHORIZATION postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;
COMMENT ON SCHEMA public IS 'Standard public schema';

regards, Angel

--
No imprima este correo si no es necesario, necesitará el dinero del papel para pagar las charlas del señor Gore.
->>-----------------------------------------------
Clist UAH a.k.a Angel
---------------------------------[www.uah.es]-<<--
"Todo despegue es opcional. Todos los aterrizajes son obligatorios."

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2008-12-11 16:12:41 Re: Data Replication
Previous Message Tom Lane 2008-12-11 13:36:11 Re: Startup process thrashing