schema or catalog? what's the diference?
| От | Angel Alvarez |
|---|---|
| Тема | schema or catalog? what's the diference? |
| Дата | |
| Msg-id | 200812111454.11970.clist@uah.es обсуждение |
| Ответы |
Re: schema or catalog? what's the diference?
|
| Список | 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."
В списке pgsql-general по дате отправления: