On 17 March 2010 21:36, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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.
I think he's having trouble finding out what the table name is in the
Maybe you can use something like this to get the name:
select relname from pg_catalog.pg_class where relkind = 'r' and
relname like 'some%thing';
where 'some%thing' is the table name with % for the part you don't know.
Using "pg_dump -s" to dump the schema might be another way to find the name.
If that doesn't help, you could perhaps get the table name like the
using a perl/python/whatever program and then in the same program
execute a DROP command using the table name you got previously.
I'd make sure you have a good backup first, though, just in case you
accidentally drop the wrong table.
Michael Wood <esiotrot(at)gmail(dot)com>
In response to
pgsql-novice by date
|Next:||From: Felix Obermaier||Date: 2010-03-17 22:17:15|
|Subject: Re: Drop table by something other than its name|
|Previous:||From: Tom Lane||Date: 2010-03-17 19:36:26|
|Subject: Re: Drop table by something other than its name |