how can we change definition of a table once created?

From: Bhuvan A <bhuvanbk(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: how can we change definition of a table once created?
Date: 2001-07-09 06:03:44
Message-ID: Pine.LNX.4.20.0107091125370.17170-100000@Larry.bks
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


hello sirs,,

can any one say how can we change the table definition once
created?

say, we have a table with 1000s of records. if one needs
to change the data type of particular column or if he
needs to change the width of a column what should be
done?

As of now, i am copying the data to a file(COPY COMMAND) and
creating a new table after deleting the old one and copying
the content of that file to the new table.

is it the only way to do it?

Bhuvan.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-07-09 06:46:03 Re: how can we change definition of a table once created?
Previous Message J.Fernando Moyano 2001-07-08 16:47:55 TOTALLY OFFTOPIC !!