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