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