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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to