title: postgresql database owner can't access database - "No relations found."
body: <p>I've got an user: user_x that owns a database on postgresql and does not have any ROLE attribute like (CREATE_DB, SUPERUSER,...)</p>
  
  <p>This user_x can access the whole DB, create tables (on his database), select, insert and update data.</p>
  
  <p>I've got this list of databases:</p>
  
  <pre><code>mydatabase=&gt; \l
                                       List of databases
            Name           |  Owner   | Encoding  | Collation | Ctype |   Access privileges   
  -------------------------+----------+-----------+-----------+-------+-----------------------
   postgres                | postgres | SQL_ASCII | C         | C     | 
   mydatabase              | user_x   | UTF8      | C         | C     | 
   template0               | postgres | SQL_ASCII | C         | C     | =c/postgres          +
                           |          |           |           |       | postgres=CTc/postgres
   template1               | postgres | SQL_ASCII | C         | C     | =c/postgres          +
                           |          |           |           |       | postgres=CTc/postgres
   whoami                  | postgres | SQL_ASCII | C         | C     | 
  (6 rows)
  </code></pre>
  
  <p>and the following roles:</p>
  
  <pre><code>mydatabase=&gt; \du
                         List of roles
   Role name |            Attributes             | Member of 
  -----------+-----------------------------------+-----------
   postgres  | Superuser, Create role, Create DB | {}
   user_x    |                                   | {}
  
  mydatabase=&gt; \d
                          List of relations
   Schema |               Name                |   Type   |  Owner   
  --------+-----------------------------------+----------+----------
   public | addresses                         | table    | user_x
   public | addresses_id_seq                  | sequence | user_x
   public | assignments                       | table    | user_x
   public | assignments_id_seq                | sequence | user_x
  
   ...
  </code></pre>
  
  <p>All right, till I dump data and restore it on another postgresql server.</p>
  
  <p>After import the data with on another server (with same database name and user) and logged on psql the <strong>\d</strong> command reply with: <strong>"No relations found."</strong></p>
  
  <p>So I added <strong>SUPERUSER</strong> role to user_x on the imported database server and tadã user_x can see the relations and data again. </p>
  
  <p>But user_x don't need to have SUPERUSER privilege to access this database.</p>
  
  <p>What's wrong with this imported dump?
  Does anyone now how to solve this?</p>