schema or catalog? what's the diference? - Mailing list pgsql-general

From Angel Alvarez
Subject schema or catalog? what's the diference?
Date
Msg-id 200812111454.11970.clist@uah.es
Whole thread Raw
Responses Re: schema or catalog? what's the diference?  ("Dave Page" <dpage@pgadmin.org>)
List 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."

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Startup process thrashing
Next
From: Jason Long
Date:
Subject: Multi-table CHECK constraint