Hi,
I am using PostgreSQL JDBC driver to connect to PostgreSQL server. And I need to get a list of tables under the current user and get information about tables - # of tables, # of columns in them, type of columns, etc.
For intanse, in oracle I could this by running:
select * from user_tables; -- give the list of tables
descr table_name; - gives information about the table
Ideas?
Thanks,
Mykola