title: How an user can access permissions on information_schema.columns of postgresql
body: <p>I created one user like below.</p>
  
  <pre><code>create role testuser1 with password 'testuser1' login; 
   alter role testuser1 with createrole createdb;
  </code></pre>
  
  <p>Now I login into postgres using the above user like below</p>
  
  <pre><code>psql -U testuser1 -d template1 
  </code></pre>
  
  <p>I got template1 command prompt. Like below</p>
  
  <pre><code>template1# 
  </code></pre>
  
  <p>After this, I create one sample database like below</p>
  
  <p>template# create database testdb;
  I was succesfully created db. Now, I exit from postgres. And again I tried to login with sample credentials, but with the database testdb and tried to import schema file(let it be test.sql) using below command</p>
  
  <pre><code>psql -h localhost -p 5432 -U testuser1 -d testdb -f "/mnt/hgfs/shared_ubuntu/sample_test_schema/pg/test.sql"
  </code></pre>
  
  <p>It's imported successfully.  After this in testdb , the below is the tables.</p>
  
  <pre>
   Schema |    Name    | Type  |  Owner   
  --------+------------+-------+----------
   public | pretabinto | table | postgres
   public | serial     | table | postgres
   public | temp       | table | postgres
  </pre>
  
  <p>Now, I tried to get tables and it's columns info using the below query. But, I am getting 0 list.</p>
  
  <pre><code>SELECT table_name,column_name,data_type 
  FROM information_schema.columns 
  WHERE table_schema NOT IN ('pg_catalog', 'information_schema');
  </code></pre>
  
  <p>How should I get columns info using the above user (like newly created user). </p>