Convert Text To Varchar : <p>In <code>Postgresql</code> how do you convert a text field to a varchar?  I have tried both of the below, but neither convert my text field to varchar.</p>

<pre><code>Cast(Iamtextfield As Varchar)
Char(Iamtextfield)
</code></pre>
