postgresql list all table fields information within a server

Question

i'm in need to create VIEWS in postresql 9, to mimic oracle's col table, basically it should display ALL table fields information from ALL table and ALL database on that server.

Can someone please point me a way? thanks.

user330315 · Accepted Answer · 2011-11-23 11:12:31Z

2

Unlike Oracle, PostgreSQL implements the ANSI information_schema.

So Oracle's ALL_TAB_COLUMNS view corresponds to information_schema.columns

But this is only restricted to the current database. It is not possible to get this information for all databases - which is the same for Oracle, ALL_TAB_COLUMNS only shows the columns for the current database (=instance)

More details about the information_schema can be found in the manual

http://www.postgresql.org/docs/current/static/information-schema.html

answered Nov 23, 2011 at 11:12

user330315

Sign up to request clarification or add additional context in comments.

Comments

fonini · Accepted Answer · 2011-11-23 11:13:29Z

1

I don't think is possible to get metadata information from a different database of that you've working right now. To extract metadata from the current database, take a look here: http://www.alberton.info/postgresql_meta_info.html

answered Nov 23, 2011 at 11:13

fonini

3,3717 gold badges36 silver badges59 bronze badges

Collectives™ on Stack Overflow

postgresql list all table fields information within a server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related