Message-ID: <5395DBC7.9050506@gmail.com>
Date: Mon, 09 Jun 2014 10:07:35 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.5.0
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Problem with strange chars in text filed.
References: 
 <CADzTWJnJ-sq9G56ev85q2NZAFVja8sZw645uxONPymqXO_EgBQ@mail.gmail.com>
In-Reply-To: 
 <CADzTWJnJ-sq9G56ev85q2NZAFVja8sZw645uxONPymqXO_EgBQ@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------040903030508090100050502"
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

This is a multi-part message in MIME format.
--------------040903030508090100050502
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 06/09/2014 10:02 AM, Bruce wrote:
> I have a table:
> create table truck (name varchar(45),address varchar(150));
>
> doing an insert:
> for i in range (0,10):
>     meme = fake.name <http://fake.name>()
>     address = fake.address()
>     print (meme,address)
>     cur.execute("INSERT INTO TRUCK2  VALUES (%s, %s)", ([meme], 
> [address]))
>     conn.commit()
>
> Heres what the data looks like:
>
> xcv=# select * from truck2;
>          name          |              address
> -----------------------+------------------------------------
>  {"Hana Mosciski"}     | {"9597 Rosalia Rue  +
>                        | South Rossie, AS 22326"}
>  {"Paisley Miller"}    | {"588 Lorin Vista   +
>                        | Merlinville, NY 79007"}
>
> Whats up with the {" on each line.
>
> Help
>
What's up with the '[' deref. in the execute?


--------------040903030508090100050502
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 06/09/2014 10:02 AM, Bruce wrote:<br>
    </div>
    <blockquote
cite="mid:CADzTWJnJ-sq9G56ev85q2NZAFVja8sZw645uxONPymqXO_EgBQ@mail.gmail.com"
      type="cite">
      <div dir="ltr">I have a table:
        <div>create table truck (name varchar(45),address varchar(150));<br>
        </div>
        <div><br>
        </div>
        <div>doing an insert: </div>
        <div>
          <div>for i in range (0,10):</div>
          <div>    meme = <a moz-do-not-send="true"
              href="http://fake.name">fake.name</a>()</div>
          <div>    address = fake.address()</div>
          <div>    print (meme,address)</div>
          <div>    cur.execute("INSERT INTO TRUCK2  VALUES (%s, %s)",
            ([meme], [address]))</div>
          <div>    conn.commit()</div>
        </div>
        <div><br>
        </div>
        <div>
          Heres what the data looks like:</div>
        <div><br>
        </div>
        <div>
          <div>xcv=# select * from truck2;</div>
          <div>         name          |              address</div>
          <div>-----------------------+------------------------------------</div>
          <div> {"Hana Mosciski"}     | {"9597 Rosalia Rue              
             +</div>
          <div>                       | South Rossie, AS 22326"}</div>
          <div> {"Paisley Miller"}    | {"588 Lorin Vista              
              +</div>
          <div>                       | Merlinville, NY 79007"}</div>
        </div>
        <div><br>
        </div>
        <div>Whats up with the {" on each line.</div>
        <div><br>
        </div>
        <div>Help</div>
        <div><br>
        </div>
      </div>
    </blockquote>
    <font size="-1"><font face="Courier New, Courier, monospace">What's
        up with the '[' deref. in the execute?<br>
        <br>
      </font></font>
  </body>
</html>

--------------040903030508090100050502--