pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Antonio Lagnada <lagnada@tbsoa.com>
To: Oliver Elphick <olly@lfix.co.uk>
Cc: Pgsql-sql <pgsql-sql@postgresql.org>
Subject: RE: Deleting a COL
Date: Sat, 1 Apr 2000 16:17:08 -0600
Message-ID: <NEBBLGHIMLDEONPJLLHHKEALCAAA.lagnada@tbsoa.com> (raw)
In-Reply-To: <200004012147.e31LkrR16199@linda.lfix.co.uk>

You're right...I tried executing the drop column command but said that it's
not yet implemented.
When is release 7.0 ready for use?

-----Original Message-----
From: Oliver Elphick [mailto:olly@lfix.co.uk]
Sent: Saturday, April 01, 2000 3:47 PM
To: Antonio Lagnada
Cc: Pgsql-sql
Subject: Re: [SQL] Deleting a COL


"Antonio Lagnada" wrote:
  >
  >Does anyone know how to delete a column in PostgreSQL?
  >I cannot find the SQL command to do it.

ALTER TABLE DROP COLUMN colname

(but I don't think it's supported before release 7.0)

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Therefore, if anyone is in Christ, he is a new
      creation; the old has gone, the new has come."
                      II Corinthians 5:17





view thread (8+ messages)  latest in thread

Message-ID: <NEBBLGHIMLDEONPJLLHHKEALCAAA.lagnada@tbsoa.com>
Permalink:  ../NEBBLGHIMLDEONPJLLHHKEALCAAA.lagnada@tbsoa.com/
Also on:    postgresql.org/message-id/NEBBLGHIMLDEONPJLLHHKEALCAAA.lagnada@tbsoa.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: lagnada@tbsoa.com, olly@lfix.co.uk
  Subject: Re: Deleting a COL
  In-Reply-To: <NEBBLGHIMLDEONPJLLHHKEALCAAA.lagnada@tbsoa.com>
  References: <200004012147.e31LkrR16199@linda.lfix.co.uk> <NEBBLGHIMLDEONPJLLHHKEALCAAA.lagnada@tbsoa.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox