Add column

From: Ioannis Theoharis <theohari(at)ics(dot)forth(dot)gr>
To: pgsql-general(at)postgresql(dot)org
Subject: Add column
Date: 2006-08-11 16:35:29
Message-ID: Pine.GSO.4.58.0608111928590.29213@calliope
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, there is a feature that I would be glad if it was supported by
PostgreSQL:

I want to add a new column (attribute) to a pre-existed table, but instead
of filling the values of this column with a default value (e.g. null) I
would like to copy them from a file stored in my filesystem.

I didn't find any example of mixing "copy" and "alter table ... add
column" in the Documentation, however I send this mail to check it out.

Thanks.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-08-11 16:40:56 Re: Tuning to speed select
Previous Message Matthew T. O'Connor 2006-08-11 16:25:58 Re: How to use the full text index feature on PostgreSQL