Thread: How to delete a table in Postgres ???
Does anyone know how to delete a table in postgresql??? I have tried all the usual commands like: delete <tablename>; del <tablename>; del table <tablename>; delete table <tablename>; Can anyone help?? Regards Sarwar
Try "DROP TABLE <tablename>". Poul L. Christiansen suhail sarwar wrote: > > Does anyone know how to delete a table in postgresql??? > > I have tried all the usual commands like: > delete <tablename>; > del <tablename>; > del table <tablename>; > delete table <tablename>; > > Can anyone help?? > > Regards > > Sarwar > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
Hello Sarwar, try: drop <tablename> Regards Lutz On Fri, 27 Apr 2001 12:57:50 +0100 "suhail sarwar" <sarwar@postmaster.co.uk> wrote: > Does anyone know how to delete a table in postgresql??? > > I have tried all the usual commands like: > delete <tablename>; > del <tablename>; > del table <tablename>; > delete table <tablename>; > > Can anyone help?? > > Regards > > Sarwar > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
In accordance with SQL92: drop table <tablename>; jeff suhail sarwar wrote: > Does anyone know how to delete a table in postgresql??? > > I have tried all the usual commands like: > delete <tablename>; > del <tablename>; > del table <tablename>; > delete table <tablename>; > > Can anyone help?? > > Regards > > Sarwar > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
drop table On Fri, 27 Apr 2001, suhail sarwar wrote: > Does anyone know how to delete a table in postgresql??? > > I have tried all the usual commands like: > delete <tablename>; > del <tablename>; > del table <tablename>; > delete table <tablename>; > > Can anyone help?? > > Regards > > Sarwar > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > ----------------------------------------------------------------------------- david@backpack.com BackPack Software, Inc. www.backpack.com +1 651.645.7550 voice "Life is an Adventure. +1 651.645.9798 fax Don't forget your BackPack!" -----------------------------------------------------------------------------
You should use drop <tablename> ; instead Johan Daine suhail sarwar a écrit : > > Does anyone know how to delete a table in postgresql??? > > I have tried all the usual commands like: > delete <tablename>; > del <tablename>; > del table <tablename>; > delete table <tablename>; > > Can anyone help?? > > Regards > > Sarwar > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
On Fri, 27 Apr 2001, suhail sarwar wrote: > Does anyone know how to delete a table in postgresql??? > > I have tried all the usual commands like: > delete <tablename>; > del <tablename>; > del table <tablename>; > delete table <tablename>; > > Can anyone help?? \h in psql shows "DROP TABLE xxx". Please read the FAQs, or at least the man page for psql. -- Joel Burton <jburton@scw.org> Director of Information Systems, Support Center of Washington
On Fri, 27 Apr 2001, suhail sarwar wrote: > Does anyone know how to delete a table in postgresql??? Standard SQL is DROP TABLE <table name> -- Brett http://www.chapelperilous.net/btfwk/ ------------------------------------------------------------------------ Nothing will ever be attempted if all possible objections must be first overcome. -- Dr. Johnson
On Fri, 27 Apr 2001, suhail sarwar wrote: > Does anyone know how to delete a table in postgresql??? > DROP TABLE <tablename> You also will need to drop the sequence if you plan to use the same table name again. DROP SEQUENCE <sequencename> You can find the sequence name by issuing the \d command in psql. -- Jeff Self Information Specialist Great Bridge, LLC www.greatbridge.com | www.greatbridge.org Norfolk, VA (757)233-5570 jeff.self@greatbridge.com