From: | Tina Messmann <tina(dot)messmann(at)xinux(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump -t and mixed case table names |
Date: | 2002-05-02 19:14:06 |
Message-ID: | 3CD18FFE.60009@xinux.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hello List,
i have a cuple of tables with mixed cased names.
I want to dump the schema from these tables (not from the whole database)
with pg_dump, but it's not working for me :(
Example:
test=# \d "TestTable"
Table "TestTable"
Column | Type | Modifiers
--------+---------------+-----------
id | integer |
name | character(10) |
Now i want to dump the schema from only this table:
postgres(at)trill:~$ pg_dump -s -t "TestTable" test
--
-- Selected TOC Entries:
--
postgres(at)trill:~$
Is it impossible to dump a table whose name is mixed cased with the -t
option?
Do i have to rename the table to lower case names to do this?
Why can i create a table with a mixed case name and then it is not
possible to dump it?
(with the -t option, when dumping the whole database, it's no problem)
Am i missing something?
My system: Debian Woody - postgresql 7.2.1 (debian package)
Regards
Tina
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2002-05-02 20:47:42 | Re: FATAL: stuck spinlock |
Previous Message | knut.suebert | 2002-05-02 19:05:36 | Re: Joe Celko Function |