From: | Angel Alvarez <clist(at)uah(dot)es> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | schema or catalog? what's the diference? |
Date: | 2008-12-11 13:54:11 |
Message-ID: | 200812111454.11970.clist@uah.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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."
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2008-12-11 16:12:41 | Re: Data Replication |
Previous Message | Tom Lane | 2008-12-11 13:36:11 | Re: Startup process thrashing |