...

Is there any way to see all the columns in the database? I have a column
that needs to be changed in all the tables that use it, without having to
check each table manually. In Sybase you would link syscolumns with
sysobjects, I can only find info on pg_tables in Postgres but none on
columns. I would like to write some sort of dynamic sql to complete my
task. Is there any way of doing this?

Thanks in advance
Jeandre