From: | Terry Mackintosh <terry(at)terrym(dot)com> |
---|---|
To: | hoelc <hoelc(at)pd(dot)jaring(dot)my> |
Cc: | PostgreSQL-development <hackers(at)postgreSQL(dot)org> |
Subject: | Re: [ADMIN] delete data |
Date: | 1999-03-18 18:14:36 |
Message-ID: | Pine.LNX.3.95.990318130649.1213A-100000@terry1.acun.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(at)terrym(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Heflin | 1999-03-18 19:27:54 | editing file after pg_dump |
Previous Message | Jonathan A. Zdziarski | 1999-03-18 18:00:28 | Changing Field Types |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-03-18 18:36:08 | Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer |
Previous Message | Zeugswetter Andreas IZ5 | 1999-03-18 17:56:39 | AW: [HACKERS] "CANNOT EXTEND" - |