Re: [GENERAL] delete columm help

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: Joao Paulo Felix <felix(at)cyclades(dot)com>
Cc: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] delete columm help
Date: 1998-05-28 04:42:15
Message-ID: 199805280542.GAA05900@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joao Paulo Felix wrote:
>Hi there,
>
>I am just starting to use PostgreSQL, and I couldn't find the answer on
>the
>PostgreSQL site...so if any one could help me it would be very
>appreciated.
>
>1) Good books/reference on PostgreSQL for a novice?

I know of no book specifically on PostgreSQL. For SQL, a very good book
is "The Practical SQL Handbook" by Bowman, Emerson and Darnovsky,
ISBN 0-201-44787-8.

>2) How do I delete a columm from a table, I have tried to use the
>following:
>
>DELETE FROM table_name columm_name

The command for changing columns in a table is ALTER TABLE. At present,
there is no facility to drop columns.

Create a new table with the correct columns; copy from the old table
to the new; DROP the old table; use ALTER TABLE to rename the new one.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Wait on the LORD; be of good courage, and he shall
strengthen thine heart; wait, I say, on the LORD."
Psalms 27:14

Browse pgsql-general by date

  From Date Subject
Next Message Tom Ivar Helbekkmo 1998-05-28 05:32:08 Re: [GENERAL] delete columm help
Previous Message Joao Paulo Felix 1998-05-27 23:41:06 delete columm help