title: insertion in Postgres database using psycopg2
body: <p>I am  inserting data into Postgresql database table by using psycopg2 
  library, but I am getting an error in the insertion command. Can anyone help me to resolve this issue?</p>
  
  <pre><code>def t_b():  
      table = 'create table {} (Title serial, Link char(50), logo_link 
      char(50), Description Text)'.format(name)  
      cur.execute(table)  
      print("Table created :", name)  
  
  def insertion(name, data):  
      data_s = ",".join(data)
      ins = 'insert into {} (Title,Link,logo_link,Description)values({})'.format(name, data_s)  
      cur.execute(ins)  
      conn.commit()  
  
  def main():  
      t_b("ONE")  
      dd = ('abc', '123', 'INsyustriesz', '&lt;htt:ps&gt;' )  
      insertion("ONE", dd)  
  
  if __name__ == '__main__':  
      main()
      cur.execute()  
  </code></pre>
  
  <p>And the error message appears:</p>
  
  <pre><code>psycopg2.errors.SyntaxError: syntax error at or near ":"  
  LINE 1: ... logo_link, Description) values(abc,123,INsyustriesz,htt:ps)
  </code></pre>
  
  <p>and data is not inserted</p>