schema or catalog? what's the diference?

Started by Angel Alvarezover 17 years ago2 messagesgeneral
Jump to latest
#1Angel 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..

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

#2Dave Page
dpage@pgadmin.org
In reply to: Angel Alvarez (#1)
Re: schema or catalog? what's the diference?

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