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 or flat)
Thread:
Lists: pgsql-novice
Kumar,

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.

Sean
----- 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
> http://mail.yahoo.com
>
> ---------------------------(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

Responses

pgsql-novice by date

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

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