Retrieving database schema
От
Gary M
Тема
Retrieving database schema
Дата
Msg-id
Pine.LNX.4.44.0303222124210.25865-100000@ruby.gem
Список
Дерево обсуждения
Retrieving database schema Gary M <postgres-general@mwwm.net>
Re: Retrieving database schema Lamar Owen <lamar.owen@wgcr.org>
Re: Retrieving database schema Tom Lane <tgl@sss.pgh.pa.us>
Re: Retrieving database schema Gary M <postgres-general@mwwm.net>
Re: Retrieving database schema Lamar Owen <lamar.owen@wgcr.org>
From embedded SQL - how do I retrieve 1) a list of the tables in the datbase? 2) a list of the columns in each table? Perhaps #1 is this: SELECT tablename FROM pg_tables WHERE NOT schemaname = 'pg_catalog'; I'm at a loss for #2 The following doesn't seem very useful: SELECT * FROM pg_class WHERE relname = 'tablename';
В списке pgsql-general по дате отправления
От: Thomas T. Thai
Дата: