information_schema.table_name contains the tables information..make sure yuo
select type BASE TABLE
and make sure the schema is not from either catalog or information_schema e.g.
SELECT table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
AND table_schema NOT IN
On Fri, Jan 30, 2009 at 6:20 PM, hendra kusuma wrote:
> I'm not talking about \d option at psql console since I need that data
> to be called from programming language such as PHP and Ruby
Here is a way to see what \d is doing:
rich...@dell-desktop:~$ psql -E -U richard
richard=> \d animals
**
