[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Restore single table
From:       Ritesh Jha <kumarritesh309 () gmail ! com>
Date:       2019-10-30 12:41:08
Message-ID: CABjKxBfx4JX0yNfDd1Wbr=vCvXW7r9nEqQLtmOPxxS6YE1GM1w () mail ! gmail ! com
[Download RAW message or body]

psql -d databaseName -f tablename.sql

On Wed, Oct 30, 2019, 5:51 PM Sonam Sharma <sonams1209@gmail.com> wrote:

> Can someone please help me with the command to restore a single table
> using psql.
>
> Took the backup using below command :
> pg_dump -t (tablename) dbname > tablename.sql
>

[Attachment #3 (text/html)]

<div dir="auto">psql -d databaseName -f tablename.sql</div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 30, 2019, 5:51 PM \
Sonam Sharma &lt;<a href="mailto:sonams1209@gmail.com">sonams1209@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">Can someone please \
help me with the command to restore a single table using psql.<div \
dir="auto"><br></div><div dir="auto">Took the backup using below command :  \
</div><div dir="auto">pg_dump -t (tablename) dbname &gt; tablename.sql</div></div> \
</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]