On Wed, 2009-12-23 at 15:49 +0000, fwoncn wrote: > I created a table named 'order' which is a reserved word in SQL by > mistake in the pgAdmin bundled with the official distribution. and now > a can't drop it in whatever way. in pgAdmin, the program hangs up when > i click on that table. and i can't drop it using the SQL line: drop > table order, cuz order is a reserved word and it's a wrong command.
Add double quotes around order: DROP TABLE "order"; -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
signature.asc
Description: This is a digitally signed message part
