Skip site navigation (1) Skip section navigation (2)

Re: New coloumns

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: "Kumar S" <ps_postgres(at)yahoo(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: New coloumns
Date: 2004-08-16 13:46:24
Message-ID: 002601c48397$6ee29560$04653744@WATSON (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

While it is possible to add columns to tables, it may be a better idea to
design your database slightly differently.  For example, if you have a data
associated with project A that gets stored into a table and there is a
possibility of having projects B and C with data for the same table, instead
of adding Project B column and Project C column, it makes more sense to have
a column in the original table design called Project.  In that column, you
store "A", "B", and "C", etc., allowing the table to grow to any number of
projects.  Thus, instead of making extra columns, simply add a key column
and your database becomes much more general and useful.

----- Original Message -----
From: "Kumar S" <ps_postgres(at)yahoo(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Monday, August 16, 2004 8:51 AM
Subject: [NOVICE] New coloumns

> Hello group,
>  I am newbie to postgrSQL and also databases.  I am
> making a database of proteins.  In one table I have 4
> columns.
>   Is it possible that after some time, I can create as
> many columns depending on the requirement. if so how
> can I add columns to my table? Is that considered as a
> major overhaul of the database.
> Please help.
> Thanks
> best
> Kumar.
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to


pgsql-novice by date

Next:From: Tom LaneDate: 2004-08-16 14:24:01
Previous:From: Kumar SDate: 2004-08-16 12:51:42
Subject: New coloumns

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group