Re: filter tables from database

From: Thom Brown <thom(at)linux(dot)com>
To: Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: filter tables from database
Date: 2010-08-11 14:46:04
Message-ID: AANLkTikb1+Hb+E9G9Bhg5stOGBJiLPn2-GxigdcxONT-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11 August 2010 15:13, Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk> wrote:
> I can retrieve the table names in my database, but I would like to filter
> them based on the name of a field. Is this possible?
> Thanks
> Garry
>
> --

Hi Garry,

You can do this:

SELECT table_name
FROM information_schema.columns
WHERE column_name = 'put_column_name_here'

Regards

Thom Brown
Registered Linux user: #516935

In response to

Browse pgsql-general by date

  From Date Subject
Next Message 3dmashup 2010-08-11 15:07:56 Re: C++ User-defined functions
Previous Message Merlin Moncure 2010-08-11 14:26:29 Re: How-to question: pre-parsing and pre-planning dynamic sql statements