Re: Getting Table Names in a Particular Database

On 08/30/11 10:26 PM, Adarsh Sharma wrote:
> Dear all,
>
> Today I am researching about fetching all the table names in a 
> particular database.
> There is \dt command but I need to fetch it from metadata.
> I find some commands as below :
>
> |1. SELECT table_name FROM information_schema.tables WHERE 
> table_schema = 'public';|

That should only return tables in the database you're currently 
connected to...

assuming you have multiple schemas in your database, I'd use something 
like...

select table_schema || '.' || table_name
     from information_schema.tables
     where table_schema not in ('pg_catalog', 'information_schema')
         and table_type = 'BASE TABLE';




-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast