Postgres Pro
Downloads
Home   >   mailing lists

Thread: Urgent

Urgent

From
"Mohammed A"
Date:
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
 
 

Re: Urgent

From
"Giorgio A."
Date:
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 -----
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