Question

drop table

0

Hi all, How can I drop just one table using Putty... I only have restoreDB available, but have errors due to owner on table and need to drop table so that restore of that table works properly. How can I do this... v2.5.5.1 app. LR.

asked 2012-03-19

Luis Rodrigues

1 answers

Roberto Postma · Answer 1 · 2012-03-19

Drop table or truncate table? (e.g. do you want to have the table removed from the database or to have all records in that table deleted?)

Anyway, you can directly fire SQL statements using the psql command (when you are running m2ee). This opens a prompt where you can fire SQL Statements, like SELECT, UPDATE, DELETE and TRUNCATE (I guess).

Of course you should be carefull using TRUNCATE and DROP TABLE commands :---)

Hope it helps!

Edit: If your goal is to restore the database and your problem is that it fails... I think you can best use the commmand emptydb to empty the database and then use restoredb