Обсуждение: BUG #5509: PostgreSQL fail to show table names containing "

The following bug has been logged online:

Bug reference:      5509
Logged by:          Fosforo Mann
Email address:      fosforo@gmail.com
PostgreSQL version: 8.1.9
Operating system:   Fedora Core release 6
Description:        PostgreSQL fail to show table names containing "
Details:

List table names successfully (they were imported from access)

Tried to view the table schema without success, and them only typing TAB TAB
it appears

teste=# \dt
        List of relations
 Schema | Name | Type  |  Owner
--------+------+-------+----------
 public | BOL  | table | postgres
 public | CLI  | table | postgres
 public | IBOL | table | postgres
 public | cta  | table | postgres
(4 rows)

teste=#
teste=#
teste=# \d BOL
Did not find any relation named "BOL".
teste=#
teste=# \d
"BOL"                cta                  information_schema.  pg_temp_1.
       public.
"CLI"                "IBOL"               pg_catalog.          pg_toast.
teste=# \d "BOL"
                  Table "public.BOL"
 Column  |              Type              | Modifiers
---------+--------------------------------+-----------
 BOLREF  | character varying(6)           |

"Fosforo Mann" <fosforo@gmail.com> wrote:

> Tried to view the table schema without success, and them only
> typing TAB TAB

If the table name contains uppercase letters, you need to type the "
before trying the TAB.

-Kevin