[postgis-users] PSQL command to drop table from a databae

[Olivier Courtin]

On Mar 28, 2010, at 12:10 PM, Shreerang Patwardhan wrote:

> Do you think that 11001_district_of_columbia_arealm is an invalid  
> table name?

Yes, label table name first char cannot be a number.


> Actually, a table with the said name can be created using psql command

Really ?

postgres=# CREATE TABLE 1a();
ERROR:  syntax error at or near "1"

with psql (PostgreSQL) 8.3.7



P.S: These kind of question is more PostgreSQL than PostGIS relevant

--
Olivier