>>>how to create field name more than 10 characteres ?
>>
>>Borislav gave you the right answer. However, I strongly advice against it, since it may cause you a lot of problems later. To quote Marcia Akins: "You may do it that way, but arsenic is usually quicker".
>
>
>I am considering this very same issue for some existing tables I have. Please explain what the issues are, or can you point me to some resources that explain what can wrong.
>
>
You will run into problems if you remove the table(s) from its container, and if you use COPY TO or another command to create a copy of the table. I seem to remember that there are other issues as well. Using long field names is on my list of things to avoid "at all cost".