pg.ddx.io pgsql-hackers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
delete columm help 2+ messages / 2 participants [nested] [flat]
* delete columm help @ 1998-05-27 23:41 Joao Paulo Felix <felix@cyclades.com> 0 siblings, 1 reply; 2+ messages in thread From: Joao Paulo Felix @ 1998-05-27 23:41 UTC (permalink / raw) To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org> 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? 2) How do I delete a columm from a table, I have tried to use the following: DELETE FROM table_name columm_name Thanks much, JP ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [GENERAL] delete columm help @ 1998-05-28 05:32 Tom Ivar Helbekkmo <tih+mail@Hamartun.Priv.NO> parent: Joao Paulo Felix <felix@cyclades.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Ivar Helbekkmo @ 1998-05-28 05:32 UTC (permalink / raw) To: Joao Paulo Felix <felix@cyclades.com>; +Cc: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org> Joao Paulo Felix <felix@cyclades.com> writes: > 1) Good books/reference on PostgreSQL for a novice? I've no particular SQL book to recommend, although I hear much good about Joe Celco's "SQL for Smarties". For a very good online tutorial, check out <http://w3.one.net/~jhoffman/sqltut.htm;. > 2) How do I delete a columm from a table, I have tried to use the > following: > > DELETE FROM table_name columm_name That should be alter table table_name drop column column_name; However, it's not yet implemented. You might rename the table, create a new one lacking the offending column, and copy the data over. On the other hand, you might just not worry about it. That's one of the great things about SQL: if you can take the space consumption hit, an extraneous column doesn't matter. Just don't "select *", which you normally shouldn't do anyway. -tih -- Popularity is the hallmark of mediocrity. --Niles Crane, "Frasier" ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-05-28 05:32 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1998-05-27 23:41 delete columm help Joao Paulo Felix <felix@cyclades.com> 1998-05-28 05:32 ` Tom Ivar Helbekkmo <tih+mail@Hamartun.Priv.NO>
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