Thread: schema or catalog? what's the diference?

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."

2008/12/11 Angel Alvarez <clist@uah.es>:
> 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..

They are the same. pgAdmin just classes the pgagent schema as a
catalog so it doesn't get in the way of your actual schemas.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com