Re: Import 2GB .sql file

Patrick Headley <[email protected]> Thu, 2 Jan 2020 16:28:41 -0700
Newsgroups	gmane.comp.db.postgresql.pgadmin
Message-ID	<[email protected]>
This is a multi-part message in MIME format.
--------------4C1A3FDEEC20C280064721D3
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Is that a 2GB backup or data file? The methods to import the data will 
be different depending on what you are starting with.

*/Patrick Headley/*
Linx Consulting, Inc.
(303) 916-5522
[email protected]
www.linxco-inc.com

On 1/2/20 4:20 PM, Christophe Pettus wrote:
>
>> On Jan 2, 2020, at 11:03, Travis Harris <[email protected]> wrote:
>>
>> I have a 2GB sql file that I need to import.
> You might try just importing it with psql; that's probably the most effective way of getting it done.
>
> --
> -- Christophe Pettus
>     [email protected]
>
>
>


--------------4C1A3FDEEC20C280064721D3
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font face="Helvetica, Arial, sans-serif">Is that a 2GB backup or
      data file? The methods to import the data will be different
      depending on what you are starting with.<br>
      <br>
    </font>
    <div class="moz-signature"><font size="3"><b><i>Patrick Headley</i></b><br>
        Linx Consulting, Inc.<br>
        (303) 916-5522<br>
        <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a><br>
        <a class="moz-txt-link-abbreviated" href="http://www.linxco-inc.com">www.linxco-inc.com</a><br>
      </font>
      <br>
    </div>
    <div class="moz-cite-prefix">On 1/2/20 4:20 PM, Christophe Pettus
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:[email protected]">
      <pre class="moz-quote-pre" wrap="">

</pre>
      <blockquote type="cite">
        <pre class="moz-quote-pre" wrap="">On Jan 2, 2020, at 11:03, Travis Harris <a class="moz-txt-link-rfc2396E" href="mailto:[email protected]">&lt;[email protected]&gt;</a> wrote:

I have a 2GB sql file that I need to import.
</pre>
      </blockquote>
      <pre class="moz-quote-pre" wrap="">
You might try just importing it with psql; that's probably the most effective way of getting it done.

--
-- Christophe Pettus
   <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a>



</pre>
    </blockquote>
    <br>
  </body>
</html>

--------------4C1A3FDEEC20C280064721D3--