Load database dump into postgres database
<p>I have a database dump about 270MB which I want to load into my local postgres database. I typed in the following command:</p>

<pre><code>pg_dump databasename &lt; dumpfile.sql
</code></pre>

<p>After which I get:</p>

<pre><code>--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


--
-- Name: public; Type: ACL; Schema: -; Owner: starlord
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM starlord;
GRANT ALL ON SCHEMA public TO starlord;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--
</code></pre>

<p>To verify if the dump was successful and to check the data I logged into the psql terminal using <code>psql</code> which opens the psql terminal.</p>

<p>If I type <code>\l</code> I get all the databases. I typed <code>\c databasename</code> to connect to the database and then <code>\dt</code> to check the tables. However it keeps showing me <code>No relations found</code>. The same steps work totally fine for other databases ( loading a dump, and then connecting and displaying tables). Moreover after loading the dump if I type <code>\l+</code> to see the size of each database, the database I am interested in shows a size of <code>6973kb</code> where as the dump is <code>272MB</code>.</p>

<p>Any suggestions as to what could be the issue?</p>