Horton

Thread

  1. How to delete a table in Postgres ???

    suhail sarwar <sarwar@postmaster.co.uk> — 2001-04-27T11:57:50Z

    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

  2. Re: How to delete a table in Postgres ???

    Lutz Steinborn <l.steinborn@4c-ag.de> — 2001-04-27T14:48:02Z

    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

  3. Re: How to delete a table in Postgres ???

    Poul L. Christiansen <poulc@cs.auc.dk> — 2001-04-27T14:48:40Z

    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

  4. Re: How to delete a table in Postgres ???

    Jeff Daugherty <jdaugherty@greatbridge.com> — 2001-04-27T14:49:55Z

    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

  5. Re: How to delete a table in Postgres ???

    Joel Burton <jburton@scw.org> — 2001-04-27T14:52:50Z

    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

  6. Re: How to delete a table in Postgres ???

    D. Duccini <duccini@backpack.com> — 2001-04-27T15:06:26Z

    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!"   
-----------------------------------------------------------------------------

  7. Re: How to delete a table in Postgres ???

    Brett W. McCoy <bmccoy@chapelperilous.net> — 2001-04-27T15:23:14Z

    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

  8. Re: How to delete a table in Postgres ???

    Johan Daine <isis@wanadoo.be> — 2001-04-27T15:26:53Z

    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

  9. Re: How to delete a table in Postgres ???

    Jeff Self <jself@greatbridge.com> — 2001-04-27T21:11:21Z

    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