From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Bhushan Bhangale <bbhangale(at)Lastminute(dot)com> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: table name in caps |
Date: | 2004-02-20 17:58:16 |
Message-ID: | Pine.LNX.4.33.0402201058030.10445-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bhushan Bhangale | 2004-02-20 18:08:29 | Re: table name in caps |
Previous Message | Bhushan Bhangale | 2004-02-20 17:32:52 | table name in caps |