A guide about some topics of Associate Certification

Oscar Calderon wrote:

Everybody have a nice day. Well, finally the place where i currently work paid me a chance to take the
Associate Certification exam and i'm reviewing some topics, specifically the topics that the exam
covers (some of them are easy to me like psql, which i use almost everyday) but i have doubt about 2
of the topics and i don't know if i already have the knowledgement about those topics.

The topics are:

* Postgres Data Dictionary: This is about information schema?

I am not sure because PostgreSQL does not use the term "data dictionary".
It *might* be this refers to the information_schema, but my bet is that
what is meant are the "system catalogs":
http://www.postgresql.org/docs/current/static/catalogs.html
Oracle uses the term "data dictionary" like that.

* Moving Data: This is about migration? Or about moving tablespaces in the file system?

I'm also not sure.
Maybe it is refering to
ALTER TABLE table_name SET TABLESPACE new_tablespace
which will move the table to a different tablespace
(different from "ALTER DATABASE db_name SET TABLESPACE new_tablespace",
which will set the default for future tables).

Other things that move data around are commands like CLUSTER,
VACUUM FULL or forms of ALTER TABLE that rewrite the table,
but I don't know if I would headline them "moving data".

Yours,
Laurenz Albe

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

On mar, 2014-03-25 at 17:50 -0600, Oscar Calderon wrote:

Hi Oscar,

I've taked the enterprisedb trainings.

Everybody have a nice day. Well, finally the place where i currently
work paid me a chance to take the Associate Certification exam and i'm
reviewing some topics, specifically the topics that the exam covers
(some of them are easy to me like psql, which i use almost everyday)
but i have doubt about 2 of the topics and i don't know if i already
have the knowledgement about those topics.

The topics are:

* Postgres Data Dictionary: This is about information schema?

It's about system catalog:
http://www.postgresql.org/docs/9.3/static/catalogs.html

* Moving Data: This is about migration? Or about moving
tablespaces in the file system?

No. It's refer to the process of import/export data using the COPY
command:
http://www.postgresql.org/docs/9.3/static/sql-copy.html

Unfortunately i don't have enough money to pay for the training so i
don't have any reference about what those topics talk about. I just
ask for your help for a reference about what does it means each topic,
just as a start point to read about it and practice.

Regards.

***************************
Oscar Calderon
Analista de Sistemas
Soluciones Aplicativas S.A. de C.V.
www.solucionesaplicativas.com
Cel. (503) 7741 7850 Tel. (503) 2522-2834

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

Ok! Now it's clear to me about what should i focus, thank you Albe and
Jaime for your help.

Regards.

***************************
Oscar Calderon
Analista de Sistemas
Soluciones Aplicativas S.A de C.V
www.solucionesaplicativas.com
Cel.(503) 7741-7850 Tel.(503) 2522-2834
Sent from my Nexus 7
On Mar 27, 2014 4:19 AM, "jaime soler" <jaime.soler@gmail.com> wrote: