Data Dictionary

Hello!

I'm new to postgresql, fairly familiar with Oracle however.

It'd be great if, in the new database I'm building, I was able to create a data
dictionary.  Essentially a table that
contains meta-data for all the other tables in the database.  Something like
this.

Already created table:
    mytable_1
    mytable_2
    yourtable_3

And the data dictionary would do something like the following:

# select * from data_dict where column_name = 'mytable_1';

table_name    column_name    data_type      nullable    data_length    etc...
----------------------------------------------------
mytable_1    mytable_col1        varchar      Y         100
etc...
mytable_1    mytable_col2         int8         Y              18
etc....
..
..



and so on.

Is there an easy way to do this in postgresql?    In oracle, all of this data is
stored in database administration
tables...are there corresponding tables in postgresql?    I'd LOVE to not have to
hand-update this table, and only
have to do something like the following:

create table data_dict as select table_name, column_name, data_type, nullable,
data_length, ... from <special
posgresql table name here>.

Any good pointers?

Saul