Thread

1. delete data

   hoelc <hoelc@pd.jaring.my> — 1999-03-18T16:41:00Z

   Hello,
   can some one please tell me how to delete a table in a database and how
   to delete one row a data in a table, for a PostgreSQL database?
   Thank you very much.
   Regards...... lch
   
   
   

2. Re: [ADMIN] delete data

   Terry Mackintosh <terry@terrym.com> — 1999-03-18T18:14:36Z

   Hi
   
   On Fri, 19 Mar 1999, hoelc wrote:
   
   > Hello,
   > can some one please tell me how to delete a table in a database and how
   > to delete one row a data in a table, for a PostgreSQL database?
   > Thank you very much.
   > Regards...... lch
   Sure, in psql:
   drop table tablename;
   delete from table tablename where ....what ever....
   
   But what it sounds like you really need is to get/read the book
   "The Practical SQL Handbook"  ISBN 0-201-44787-8
   Mine is the 3rd edition, check if there is a newer one.
   
   Have a great day
   Terry Mackintosh <terry@terrym.com>               http://www.terrym.com
   sysadmin/owner                  I'm excited about life! How about YOU!?
   Professional Web Hosting and site design to include programming
   Proudly powered by R H Linux 4.2, Apache 1.3.x, PHP 3.x, PostgreSQL 6.x
   -----------------------------------------------------------------------
   Only if you know where you're going can you get there.