<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Since you are using a non-standard way of naming your table (starting
with number), as Oliver was explaining, you need to double quote your
table name.<br>
<tt><br>
$ set mytab=\"123foo\"<br>
<br>
$ echo $mytab<br>
"foo"<br>
<br>
$ psql -c "CREATE TABLE $mytab( a int ) " postgis <br>
CREATE TABLE<br>
<br>
$ psql -c "\dt" postgis<br>
List of relations<br>
Schema | Name | Type | Owner <br>
--------+------------------+-------+----------<br>
public | 123foo | table | kneufeld<br>
public | geometry_columns | table | kneufeld<br>
public | spatial_ref_sys | table | kneufeld<br>
(3 rows)<br>
<br>
$ psql -c "DROP TABLE $mytab" postgis<br>
DROP TABLE</tt><br>
<br>
-- Kevin<br>
<br>
On 3/28/2010 8:35 AM, Shreerang Patwardhan wrote:
<blockquote
cite="mid:5dd65e1e1003280835s135ada5egd17942c840c80540@mail.gmail.com"
type="cite">Hi Ollvier,<br>
I was just writing to you about your previous mail. Well, th e DROP
TABLE command is not working at my end. I have used double quotes also.
Can you guess what could the problem be? I am trying to use that
command in a shell script and it is not working. I have also tried it
on the terminal and still the result is the same....ERROR!!!.....<img
goomoji="gtalk.325" style="margin: 0pt 0.2ex; vertical-align: middle;"
src="cid:part1.01050205.08000105@refractions.net"><br>
Need help!!!<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>