Content-Type: multipart/alternative;
 boundary="------------cM3VUxcuq6kA4KdyA0dMKN2y"
Message-ID: <27d37670-c38f-69f9-9a9b-52a1775b32a0@gmail.com>
Date: Wed, 16 Nov 2022 10:12:20 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.2.2
Subject: Re: backup to partitioned table
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CA+dvXXt=G+a=4C5j8rn9ZTjP+g-6tu3MtnMC0cKbWSH5Nk5ovA@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CA+dvXXt=G+a=4C5j8rn9ZTjP+g-6tu3MtnMC0cKbWSH5Nk5ovA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/27d37670-c38f-69f9-9a9b-52a1775b32a0%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------cM3VUxcuq6kA4KdyA0dMKN2y
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 11/16/22 09:56, Erik Serrano wrote:
> Hello Guys,
> I have a case that I would like you to help me with.
>
> I have a partitioned table in postgresql version 9,5 to which I select and 
> it returns data perfectly, but when I want to make a backup of the table, 
> it only saves the structure without records.
> It should be noted that I am not making a backup of the structure, but of 
> the data or complete, but it does not back up the data anyway.
> When consulting the administrator, he informs me that it is a partitioned 
> table and that it is always zero, but the data is in its "daughter" tables 
> and that the select that it returns is the information that is housed in 
> all its daughter tables.

That is correct.

>
> Now, given this, I wanted to know if there is any way to make a backup of 
> the table that throws all the data from its child tables *into a flat file*.

Flat file as in a CSV file?

>
> Is it possible to perform this action?

If you want to export it to a CSV (or tab-separated, etc, etc) flat file, 
then -- if using psql, use the COPY or \COPY command; instead of simply 
specifying a table name, copy the *query* (SELECT * FROM parent_table).

If that's not what you mean, please clarify.

-- 
Angular momentum makes the world go 'round.
--------------cM3VUxcuq6kA4KdyA0dMKN2y
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 11/16/22 09:56, Erik Serrano wrote:<br>
    <blockquote type="cite"
cite="mid:CA+dvXXt=G+a=4C5j8rn9ZTjP+g-6tu3MtnMC0cKbWSH5Nk5ovA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">Hello Guys, 
        <div>I have a case that I would like you to help me with.</div>
        <div><br>
          <div>I have a partitioned table in postgresql version 9,5 to
            which I select and it returns data perfectly, but when I
            want to make a backup of the table, it only saves the
            structure without records.<br>
            It should be noted that I am not making a backup of the
            structure, but of the data or complete, but it does not back
            up the data anyway.<br>
            When consulting the administrator, he informs me that it is
            a partitioned table and that it is always zero, but the data
            is in its "daughter" tables and that the select that it
            returns is the information that is housed in all its
            daughter tables.<br>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    That is correct.<br>
    <br>
    <blockquote type="cite"
cite="mid:CA+dvXXt=G+a=4C5j8rn9ZTjP+g-6tu3MtnMC0cKbWSH5Nk5ovA@mail.gmail.com">
      <div dir="ltr">
        <div>
          <div><br>
            Now, given this, I wanted to know if there is any way to
            make a backup of the table that throws all the data from its
            child tables <b>into a flat file</b>.<br>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    Flat file as in a CSV file?<br>
    <br>
    <blockquote type="cite"
cite="mid:CA+dvXXt=G+a=4C5j8rn9ZTjP+g-6tu3MtnMC0cKbWSH5Nk5ovA@mail.gmail.com">
      <div dir="ltr">
        <div>
          <div><br>
            Is it possible to perform this action?<br>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    If you want to export it to a CSV (or tab-separated, etc, etc) flat
    file, then -- if using psql, use the COPY or \COPY command; instead
    of simply specifying a table name, copy the <b>query</b> (SELECT *
    FROM parent_table).<br>
    <br>
    If that's not what you mean, please clarify.<br>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------cM3VUxcuq6kA4KdyA0dMKN2y--