Re: metadata searching

Oliver Jowett wrote:

> $ psql testdb
> Welcome to psql 7.4.1, the PostgreSQL interactive terminal.
> [...]
> testdb=> create table "test" (k int4);
> CREATE TABLE
> testdb=> create table "Test" (q int4);
> CREATE TABLE
> testdb=> \d "test"
> Table "public.test"
> Column | Type | Modifiers
> --------+---------+-----------
> k | integer |
>
> testdb=> \d "Test"
> Table "public.Test"
> Column | Type | Modifiers
> --------+---------+-----------
> q | integer |

Eh, and of course the case actually relevant to your original example..

testdb=> \d test
Table "public.test"
Column | Type | Modifiers
--------+---------+-----------
k | integer |

testdb=> drop table test;
DROP TABLE
testdb=> \d test
Did not find any relation named "test".
testdb=> \d "Test"
Table "public.Test"
Column | Type | Modifiers
--------+---------+-----------
q | integer |

-O