Re: Urgent

donnow if i understood your answer: did u mispelled the name of a column ?

if so, you'll need the ALTER command ( do a "\h alter" :-)

btw, it's something like:

ALTER TABLE name_of_the_table RENAME COLUMN l_ega TO l_age

hope this helps

bye
Giorgio A.
----- Original Message -----
From: Mohammed A
To: pgsql-novice(at)postgresql(dot)org
Sent: Tuesday, June 12, 2001 11:37 AM
Subject: [NOVICE] Urgent

table has been created.and data also copied it to that table,

but I realise that on of the attribute name is written wrongly. for example the attribute name
L_AGE it has been written L_EGA.

IS ANY WAY TO CORRECT IT