Skip site navigation (1) Skip section navigation (2)

BUG #5509: PostgreSQL fail to show table names containing "

From: "Fosforo Mann" <fosforo(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5509: PostgreSQL fail to show table names containing "
Date: 2010-06-17 19:27:39
Message-ID: 201006171927.o5HJRdek010633@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5509
Logged by:          Fosforo Mann
Email address:      fosforo(at)gmail(dot)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)           |

Responses

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2010-06-17 22:05:07
Subject: Re: BUG #5509: PostgreSQL fail to show table names containing "
Previous:From: Tom LaneDate: 2010-06-17 15:59:18
Subject: Re: BUG #5508: wrong type of argument

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group