| From: | "Marcin Krawczyk" <jankes(dot)mk(at)gmail(dot)com> |
|---|---|
| To: | "Peter Eisentraut" <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: table column names - search |
| Date: | 2008-01-14 18:30:49 |
| Message-ID: | 95f6bf9b0801141030h1ffcdad3q1d8e79f0aba4335@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Thanks a lot.
2008/1/14, Peter Eisentraut <peter_e(at)gmx(dot)net>:
>
> Am Montag, 14. Januar 2008 schrieb Marcin Krawczyk:
> > Hi all. I would like to know if there's a way to obtain a list of tables
> > containing specified column name? Using standard LIKE '%string' syntax
> > would be great.
>
> SELECT table_schema, table_name FROM information_schema.columns WHERE
> column_name LIKE '%name%';
>
> Add DISTINCT and other columns to taste.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Medi Montaseri | 2008-01-14 19:01:36 | Re: UTF8 encoding and non-text data types |
| Previous Message | Peter Eisentraut | 2008-01-14 17:24:11 | Re: table column names - search |