Hey all,
Do you'll think that 11001_district_of_columbia_arealm is an invalid
table name? Actually, a table with the said name can be created using psql
command as well as through pgadmin3. But then why does it give an error
while deleting this table? The error message reads as:
ERROR: syntax
Hey all,
I am trying the following command to drop a table from a postgresql
database. It gives an error. Can anyone please rectify the command if it is
wrong?
*Command:*
psql -h localhost -p 5433 -U postgres -d testdb -c DROP TABLE
11001_district_of_columbia_arealm
*Error Message:*
psql:
On Sun, Mar 28, 2010 at 9:41 AM, Shreerang Patwardhan
patwardhan.shreer...@gmail.com wrote:
Hey all,
I am trying the following command to drop a table from a postgresql
database. It gives an error. Can anyone please rectify the command if it is
wrong?
*Command:*
psql -h localhost -p 5433
You forgot to quote your sql statement. Hence the interpreter threw an error
at the DROP keyword.
psql -h localhost -p 5433 -U postgres -d testdb -c DROP TABLE
11001_district_of_columbia_arealm
-rohit
On Sun, Mar 28, 2010 at 9:41 AM, Shreerang Patwardhan
patwardhan.shreer...@gmail.com wrote: