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

Re: Drop table by something other than its name

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Felix Obermaier <obe(at)IVV-AACHEN(dot)DE>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Drop table by something other than its name
Date: 2010-03-17 19:36:26
Message-ID: 24487.1268854586@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Felix Obermaier <obe(at)IVV-AACHEN(dot)DE> writes:
> I have a table with a name that contains some akward letter in it so that pgAdmin fails to display it (just empty) and psql omits that character.
> My problem is that I cannot query that table and I cannot drop it. Is there a way to get rid of this table?

You probably just need to double-quote the table name.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Michael WoodDate: 2010-03-17 21:33:34
Subject: Re: Drop table by something other than its name
Previous:From: TavDate: 2010-03-17 16:40:06
Subject: row v column numbers

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