title: How to convert a nested json column from postgresql database to dataframe with python or with query?
body: <p>How to convert a nested json from a postgresql table to dataframe with python or using direct query?</p>
  
  <p>The json object looks like     </p>
  
  <pre><code>[
    {
      "personName": "Aly Michalka",
      "characterName": "Aly Michalka",
      "creditType": "Actor"
    },
    {
      "personName": "Malcolm McDowell",
      "characterName": "Malcolm McDowell",
      "creditType": "Actor"
    },
    {
      "personName": "Lisa Kudrow",
      "characterName": "Lisa Kudrow",
      "creditType": "Actor"
    },
    {
      "personName": "Cam Gigandet",
      "characterName": "Cam Gigandet",
      "creditType": "Actor"
    },
    {
      "personName": "Patricia Clarkson",
      "characterName": "Patricia Clarkson",
      "creditType": "Actor"
    },
    {
      "personName": "Thomas Haden Church",
      "characterName": "Thomas Haden Church",
      "creditType": "Actor"
    },
    {
      "personName": "Amanda Bynes",
      "characterName": "Amanda Bynes",
      "creditType": "Actor"
    },
    {
      "personName": "Penn Badgley",
      "characterName": "Penn Badgley",
      "creditType": "Actor"
    },
    {
      "personName": "Emma Stone",
      "characterName": "Emma Stone",
      "creditType": "Actor"
    },
    {
      "personName": "Will Gluck",
      "characterName": "Will Gluck",
      "creditType": "Director"
    }
  ]
  </code></pre>
  
  <p>This entire json object should correspond to a particular column of dataframe.</p>