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

Re: table name in caps

From: Bhushan Bhangale <bbhangale(at)Lastminute(dot)com>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: table name in caps
Date: 2004-02-20 18:08:29
Message-ID: C9590F897BFAD7119E63000BCD682083C672B0@lmnukpriv.lastminute.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Thanks!
It worked.

-----Original Message-----
From: scott.marlowe [mailto:scott(dot)marlowe(at)ihs(dot)com]
Sent: 20 February 2004 17:58
To: Bhushan Bhangale
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] table name in caps


Just quote it:

drop table "Resorts";

On Fri, 20 Feb 2004, Bhushan Bhangale wrote:

> Hi,
> 
> I accidently created a table named Resorts (see R in caps).
> 
> Now i can't drop this table nor i can access this table. I get error ->
> 
> Error: ERROR:  table "resorts" does not exist (State:S1000, Native Code:
7)
> 
> Thanks
> 
> Bhushan Bhangale
> Senior Systems Executive
> 
> address: 4 Buckingham Gate, London SW1E 6JP
> tel: +44 (0)20 7802 4283
> mob: +44 (0)79 5829 5054
> email: BBhangale(at)lastminute(dot)com
> 
> do something lastminute.com
> 
> 
> ________________________________________________________________________
> This e-mail has been scanned for all viruses by Star Internet. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
> ________________________________________________________________________
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> 


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

pgsql-jdbc by date

Next:From: WaldomiroDate: 2004-02-20 19:21:52
Subject: I forgot the "Begin" command, what should I do ?
Previous:From: scott.marloweDate: 2004-02-20 17:58:16
Subject: Re: table name in caps

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