Hello all!
I have a postgresql 9.3 database with a table (mytable) and column (mycolumn) that was created from within developer
The column is listed in developer as TEXT and 5000 in length
I viewed it in psql \d mycolumn and saw the column was actually varchar and not "TEXT" as specified in developer
I changed the size in PGadmin to 10,000 but developer will not see the difference
How can get developer to recognize the change in this column?
I physically rebooted the computer in hopes that would help but it did not
Is my only solution to do a pg_dump, delete the column from within developer, re-create the column to match the size in postgresql and pg_restore?
Thanks for any input