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