title: PostgreSQL COPY FROM STDIN Expressions
body: <p>I am attempting to use COPY FROM STDIN to import data into my table. One of the columns in my table is of type geometry. My command looks something like this...</p>
  
  <pre><code>COPY "WeatherStations" ("Station_ID", "Station_Code", "Station_Name", "Station_Location") FROM stdin;
  1       KAVP    WILKES-BARRE    ST_GeomFromText('POINT(41.338055 -75.724166)')
  2       KOKV    WINCHESTER      ST_GeomFromText('POINT(39.143333 -78.144444)')
  3       KSHD    SHENANDOAH      ST_GeomFromText('POINT(38.263611 -78.896388)')
  ...
  </code></pre>
  
  <p>However, I think it is attempting to insert the text "ST_GeomFromText('POINT..." and failing instead of evaluating the expression and inserting the result of the expression. Does anyone know what might be going on here and how I can get the actual geoms inserted?</p>