.\" Man page generated from reStructuredText.
.
.
.nr rst2man-indent-level 0
.
.de1 rstReportMargin
\\$1 \\n[an-margin]
level \\n[rst2man-indent-level]
level margin: \\n[rst2man-indent\\n[rst2man-indent-level]]
-
\\n[rst2man-indent0]
\\n[rst2man-indent1]
\\n[rst2man-indent2]
..
.de1 INDENT
.\" .rstReportMargin pre:
. RS \\$1
. nr rst2man-indent\\n[rst2man-indent-level] \\n[an-margin]
. nr rst2man-indent-level +1
.\" .rstReportMargin post:
..
.de UNINDENT
. RE
.\" indent \\n[an-margin]
.\" old: \\n[rst2man-indent\\n[rst2man-indent-level]]
.nr rst2man-indent-level -1
.\" new: \\n[rst2man-indent\\n[rst2man-indent-level]]
.in \\n[rst2man-indent\\n[rst2man-indent-level]]u
..
.TH "PGCOPYDB LIST" "1" "Mar 15, 2023" "0.11" "pgcopydb"
.SH NAME
pgcopydb list \- pgcopydb list
.sp
pgcopydb list \- List database objects from a Postgres instance
.sp
This command prefixes the following sub\-commands:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
pgcopydb list
  extensions   List all the source extensions to copy
  collations   List all the source collations to copy
  tables       List all the source tables to copy data from
  table\-parts  List a source table copy partitions
  sequences    List all the source sequences to copy data from
  indexes      List all the indexes to create again after copying the data
  depends      List all the dependencies to filter\-out
  schema       List the schema to migrate, formatted in JSON
  progress     List the progress
.ft P
.fi
.UNINDENT
.UNINDENT
.SH PGCOPYDB LIST EXTENSIONS
.sp
pgcopydb list extensions \- List all the source extensions to copy
.sp
The command \fBpgcopydb list extensions\fP connects to the source database and
executes a SQL query using the Postgres catalogs to get a list of all the
extensions to COPY to the target database.
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
pgcopydb list extensions: List all the source extensions to copy
usage: pgcopydb list extensions  \-\-source ...

  \-\-source            Postgres URI to the source database
.ft P
.fi
.UNINDENT
.UNINDENT
.SH PGCOPYDB LIST COLLATIONS
.sp
pgcopydb list collations \- List all the source collations to copy
.sp
The command \fBpgcopydb list collations\fP connects to the source database and
executes a SQL query using the Postgres catalogs to get a list of all the
collations to COPY to the target database.
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
pgcopydb list collations: List all the source collations to copy
usage: pgcopydb list collations  \-\-source ...

  \-\-source            Postgres URI to the source database
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
The SQL query that is used lists the database collation, and then any
non\-default collation that\(aqs used in a user column or a user index.
.SH PGCOPYDB LIST TABLES
.sp
pgcopydb list tables \- List all the source tables to copy data from
.sp
The command \fBpgcopydb list tables\fP connects to the source database and
executes a SQL query using the Postgres catalogs to get a list of all the
tables to COPY the data from.
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
pgcopydb list tables: List all the source tables to copy data from
usage: pgcopydb list tables  \-\-source ...

  \-\-source            Postgres URI to the source database
  \-\-filter <filename> Use the filters defined in <filename>
  \-\-cache             Cache table size in relation pgcopydb.table_size
  \-\-drop\-cache        Drop relation pgcopydb.table_size
  \-\-list\-skipped      List only tables that are setup to be skipped
  \-\-without\-pkey      List only tables that have no primary key
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
The \fB\-\-cache\fP option allows caching the \fI\%pg_table_size()\fP result in the
newly created table \fBpgcopydb.table_size\fP\&. This is only useful in Postgres
deployments where this computation is quite slow, and when the pgcopydb
operation is going to be run multiple times.
.SH PGCOPYDB LIST TABLE-PARTS
.sp
pgcopydb list table\-parts \- List a source table copy partitions
.sp
The command \fBpgcopydb list table\-parts\fP connects to the source database
and executes a SQL query using the Postgres catalogs to get detailed
information about the given source table, and then another SQL query to
compute how to split this source table given the size threshold argument.
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
pgcopydb list table\-parts: List a source table copy partitions
usage: pgcopydb list table\-parts  \-\-source ...

  \-\-source                    Postgres URI to the source database
  \-\-schema\-name               Name of the schema where to find the table
  \-\-table\-name                Name of the target table
  \-\-split\-tables\-larger\-than  Size threshold to consider partitioning
.ft P
.fi
.UNINDENT
.UNINDENT
.SH PGCOPYDB LIST SEQUENCES
.sp
pgcopydb list sequences \- List all the source sequences to copy data from
.sp
The command \fBpgcopydb list sequences\fP connects to the source database and
executes a SQL query using the Postgres catalogs to get a list of all the
sequences to COPY the data from.
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
pgcopydb list sequences: List all the source sequences to copy data from
usage: pgcopydb list sequences  \-\-source ...

  \-\-source            Postgres URI to the source database
  \-\-filter <filename> Use the filters defined in <filename>
  \-\-list\-skipped      List only tables that are setup to be skipped
.ft P
.fi
.UNINDENT
.UNINDENT
.SH PGCOPYDB LIST INDEXES
.sp
pgcopydb list indexes \- List all the indexes to create again after copying the data
.sp
The command \fBpgcopydb list indexes\fP connects to the source database and
executes a SQL query using the Postgres catalogs to get a list of all the
indexes to COPY the data from.
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
pgcopydb list indexes: List all the indexes to create again after copying the data
usage: pgcopydb list indexes  \-\-source ... [ \-\-schema\-name [ \-\-table\-name ] ]

  \-\-source            Postgres URI to the source database
  \-\-schema\-name       Name of the schema where to find the table
  \-\-table\-name        Name of the target table
  \-\-filter <filename> Use the filters defined in <filename>
  \-\-list\-skipped      List only tables that are setup to be skipped
.ft P
.fi
.UNINDENT
.UNINDENT
.SH PGCOPYDB LIST DEPENDS
.sp
pgcopydb list depends \- List all the dependencies to filter\-out
.sp
The command \fBpgcopydb list depends\fP connects to the source database and
executes a SQL query using the Postgres catalogs to get a list of all the
objects that depend on excluded objects from the filtering rules.
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
pgcopydb list depends: List all the dependencies to filter\-out
usage: pgcopydb list depends  \-\-source ... [ \-\-schema\-name [ \-\-table\-name ] ]

  \-\-source            Postgres URI to the source database
  \-\-schema\-name       Name of the schema where to find the table
  \-\-table\-name        Name of the target table
  \-\-filter <filename> Use the filters defined in <filename>
  \-\-list\-skipped      List only tables that are setup to be skipped
.ft P
.fi
.UNINDENT
.UNINDENT
.SH PGCOPYDB LIST SCHEMA
.sp
pgcopydb list schema \- List the schema to migrate, formatted in JSON
.sp
The command \fBpgcopydb list schema\fP connects to the source database and
executes a SQL queries using the Postgres catalogs to get a list of the
tables, indexes, and sequences to migrate. The command then outputs a JSON
formatted string that contains detailed information about all those objects.
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
pgcopydb list schema: List the schema to migrate, formatted in JSON
usage: pgcopydb list schema  \-\-source ...

  \-\-source            Postgres URI to the source database
  \-\-filter <filename> Use the filters defined in <filename>
.ft P
.fi
.UNINDENT
.UNINDENT
.SH PGCOPYDB LIST PROGRESS
.sp
pgcopydb list progress \- List the progress
.sp
The command \fBpgcopydb list progress\fP reads the \fBschema.json\fP file in the
work directory, parses it, and then computes how many tables and indexes are
planned to be copied and created on the target database, how many have been
done already, and how many are in\-progress.
.sp
When using the option \fB\-\-json\fP the JSON formatted output also includes a
list of all the tables and indexes that are currently being processed.
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
pgcopydb list progress: List the progress
usage: pgcopydb list progress  \-\-source ...

  \-\-source  Postgres URI to the source database
  \-\-json    Format the output using JSON
.ft P
.fi
.UNINDENT
.UNINDENT
.SH OPTIONS
.sp
The following options are available to \fBpgcopydb dump schema\fP:
.INDENT 0.0
.TP
.B  \-\-source
Connection string to the source Postgres instance. See the Postgres
documentation for \fI\%connection strings\fP for the details. In short both
the quoted form \fB\(dqhost=... dbname=...\(dq\fP and the URI form
\fBpostgres://user@host:5432/dbname\fP are supported.
.TP
.B  \-\-schema\-name
Filter indexes from a given schema only.
.TP
.B  \-\-table\-name
Filter indexes from a given table only (use \fB\-\-schema\-name\fP to fully
qualify the table).
.TP
.B  \-\-without\-pkey
List only tables from the source database when they have no primary key
attached to their schema.
.TP
.BI \-\-filter \ <filename>
This option allows to skip objects in the list operations. See
\fI\%Filtering\fP for details about the expected file format and the
filtering options available.
.TP
.B  \-\-list\-skipped
Instead of listing objects that are selected for copy by the filters
installed with the \fB\-\-filter\fP option, list the objects that are going to
be skipped when using the filters.
.TP
.B  \-\-json
The output of the command is formatted in JSON, when supported. Ignored
otherwise.
.TP
.B  \-\-verbose
Increase current verbosity. The default level of verbosity is INFO. In
ascending order pgcopydb knows about the following verbosity levels:
FATAL, ERROR, WARN, INFO, NOTICE, DEBUG, TRACE.
.TP
.B  \-\-debug
Set current verbosity to DEBUG level.
.TP
.B  \-\-trace
Set current verbosity to TRACE level.
.TP
.B  \-\-quiet
Set current verbosity to ERROR level.
.UNINDENT
.SH ENVIRONMENT
.sp
PGCOPYDB_SOURCE_PGURI
.INDENT 0.0
.INDENT 3.5
Connection string to the source Postgres instance. When \fB\-\-source\fP is
ommitted from the command line, then this environment variable is used.
.UNINDENT
.UNINDENT
.SH EXAMPLES
.sp
Listing the tables:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
$ pgcopydb list tables
14:35:18 13827 INFO  Listing ordinary tables in \(dqport=54311 host=localhost dbname=pgloader\(dq
14:35:19 13827 INFO  Fetched information for 56 tables
     OID |          Schema Name |           Table Name |  Est. Row Count |    On\-disk size
\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-
   17085 |                  csv |                track |            3503 |          544 kB
   17098 |             expected |                track |            3503 |          544 kB
   17290 |             expected |           track_full |            3503 |          544 kB
   17276 |               public |           track_full |            3503 |          544 kB
   17016 |             expected |            districts |             440 |           72 kB
   17007 |               public |            districts |             440 |           72 kB
   16998 |                  csv |               blocks |             460 |           48 kB
   17003 |             expected |               blocks |             460 |           48 kB
   17405 |                  csv |              partial |               7 |           16 kB
   17323 |                  err |               errors |               0 |           16 kB
   16396 |             expected |              allcols |               0 |           16 kB
   17265 |             expected |                  csv |               0 |           16 kB
   17056 |             expected |      csv_escape_mode |               0 |           16 kB
   17331 |             expected |               errors |               0 |           16 kB
   17116 |             expected |                group |               0 |           16 kB
   17134 |             expected |                 json |               0 |           16 kB
   17074 |             expected |             matching |               0 |           16 kB
   17201 |             expected |               nullif |               0 |           16 kB
   17229 |             expected |                nulls |               0 |           16 kB
   17417 |             expected |              partial |               0 |           16 kB
   17313 |             expected |              reg2013 |               0 |           16 kB
   17437 |             expected |               serial |               0 |           16 kB
   17247 |             expected |                 sexp |               0 |           16 kB
   17378 |             expected |                test1 |               0 |           16 kB
   17454 |             expected |                  udc |               0 |           16 kB
   17471 |             expected |                xzero |               0 |           16 kB
   17372 |               nsitra |                test1 |               0 |           16 kB
   16388 |               public |              allcols |               0 |           16 kB
   17256 |               public |                  csv |               0 |           16 kB
   17047 |               public |      csv_escape_mode |               0 |           16 kB
   17107 |               public |                group |               0 |           16 kB
   17125 |               public |                 json |               0 |           16 kB
   17065 |               public |             matching |               0 |           16 kB
   17192 |               public |               nullif |               0 |           16 kB
   17219 |               public |                nulls |               0 |           16 kB
   17307 |               public |              reg2013 |               0 |           16 kB
   17428 |               public |               serial |               0 |           16 kB
   17238 |               public |                 sexp |               0 |           16 kB
   17446 |               public |                  udc |               0 |           16 kB
   17463 |               public |                xzero |               0 |           16 kB
   17303 |             expected |              copyhex |               0 |      8192 bytes
   17033 |             expected |           dateformat |               0 |      8192 bytes
   17366 |             expected |                fixed |               0 |      8192 bytes
   17041 |             expected |              jordane |               0 |      8192 bytes
   17173 |             expected |           missingcol |               0 |      8192 bytes
   17396 |             expected |             overflow |               0 |      8192 bytes
   17186 |             expected |              tab_csv |               0 |      8192 bytes
   17213 |             expected |                 temp |               0 |      8192 bytes
   17299 |               public |              copyhex |               0 |      8192 bytes
   17029 |               public |           dateformat |               0 |      8192 bytes
   17362 |               public |                fixed |               0 |      8192 bytes
   17037 |               public |              jordane |               0 |      8192 bytes
   17164 |               public |           missingcol |               0 |      8192 bytes
   17387 |               public |             overflow |               0 |      8192 bytes
   17182 |               public |              tab_csv |               0 |      8192 bytes
   17210 |               public |                 temp |               0 |      8192 bytes
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
Listing a table list of COPY partitions:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
$ pgcopydb list table\-parts \-\-table\-name rental \-\-split\-at 300kB
16:43:26 73794 INFO  Running pgcopydb version 0.8.8.g0838291.dirty from \(dq/Users/dim/dev/PostgreSQL/pgcopydb/src/bin/pgcopydb/pgcopydb\(dq
16:43:26 73794 INFO  Listing COPY partitions for table \(dqpublic\(dq.\(dqrental\(dq in \(dqpostgres://@:/pagila?\(dq
16:43:26 73794 INFO  Table \(dqpublic\(dq.\(dqrental\(dq COPY will be split 5\-ways
      Part |        Min |        Max |      Count
\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-
       1/5 |          1 |       3211 |       3211
       2/5 |       3212 |       6422 |       3211
       3/5 |       6423 |       9633 |       3211
       4/5 |       9634 |      12844 |       3211
       5/5 |      12845 |      16049 |       3205
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
Listing the indexes:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
$ pgcopydb list indexes
14:35:07 13668 INFO  Listing indexes in \(dqport=54311 host=localhost dbname=pgloader\(dq
14:35:07 13668 INFO  Fetching all indexes in source database
14:35:07 13668 INFO  Fetched information for 12 indexes
     OID |     Schema |           Index Name |         conname |                Constraint | DDL
\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-
   17002 |        csv |      blocks_ip4r_idx |                 |                           | CREATE INDEX blocks_ip4r_idx ON csv.blocks USING gist (iprange)
   17415 |        csv |        partial_b_idx |                 |                           | CREATE INDEX partial_b_idx ON csv.partial USING btree (b)
   17414 |        csv |        partial_a_key |   partial_a_key |                UNIQUE (a) | CREATE UNIQUE INDEX partial_a_key ON csv.partial USING btree (a)
   17092 |        csv |           track_pkey |      track_pkey |     PRIMARY KEY (trackid) | CREATE UNIQUE INDEX track_pkey ON csv.track USING btree (trackid)
   17329 |        err |          errors_pkey |     errors_pkey |           PRIMARY KEY (a) | CREATE UNIQUE INDEX errors_pkey ON err.errors USING btree (a)
   16394 |     public |         allcols_pkey |    allcols_pkey |           PRIMARY KEY (a) | CREATE UNIQUE INDEX allcols_pkey ON public.allcols USING btree (a)
   17054 |     public | csv_escape_mode_pkey | csv_escape_mode_pkey |          PRIMARY KEY (id) | CREATE UNIQUE INDEX csv_escape_mode_pkey ON public.csv_escape_mode USING btree (id)
   17199 |     public |          nullif_pkey |     nullif_pkey |          PRIMARY KEY (id) | CREATE UNIQUE INDEX nullif_pkey ON public.\(dqnullif\(dq USING btree (id)
   17435 |     public |          serial_pkey |     serial_pkey |           PRIMARY KEY (a) | CREATE UNIQUE INDEX serial_pkey ON public.serial USING btree (a)
   17288 |     public |      track_full_pkey | track_full_pkey |     PRIMARY KEY (trackid) | CREATE UNIQUE INDEX track_full_pkey ON public.track_full USING btree (trackid)
   17452 |     public |             udc_pkey |        udc_pkey |           PRIMARY KEY (b) | CREATE UNIQUE INDEX udc_pkey ON public.udc USING btree (b)
   17469 |     public |           xzero_pkey |      xzero_pkey |           PRIMARY KEY (a) | CREATE UNIQUE INDEX xzero_pkey ON public.xzero USING btree (a)
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
Listing the schema in JSON:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
$ pgcopydb list schema \-\-split\-at 200kB
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
This gives the following JSON output:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
{
    \(dqsetup\(dq: {
        \(dqsnapshot\(dq: \(dq00000003\-00051AAE\-1\(dq,
        \(dqsource_pguri\(dq: \(dqpostgres:\e/\e/@:\e/pagila?\(dq,
        \(dqtarget_pguri\(dq: \(dqpostgres:\e/\e/@:\e/plop?\(dq,
        \(dqtable\-jobs\(dq: 4,
        \(dqindex\-jobs\(dq: 4,
        \(dqsplit\-tables\-larger\-than\(dq: 204800
    },
    \(dqtables\(dq: [
        {
            \(dqoid\(dq: 317934,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqrental\(dq,
            \(dqreltuples\(dq: 16044,
            \(dqbytes\(dq: 1253376,
            \(dqbytes\-pretty\(dq: \(dq1224 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic rental postgres\(dq,
            \(dqpart\-key\(dq: \(dqrental_id\(dq,
            \(dqparts\(dq: [
                {
                    \(dqnumber\(dq: 1,
                    \(dqtotal\(dq: 7,
                    \(dqmin\(dq: 1,
                    \(dqmax\(dq: 2294,
                    \(dqcount\(dq: 2294
                },
                {
                    \(dqnumber\(dq: 2,
                    \(dqtotal\(dq: 7,
                    \(dqmin\(dq: 2295,
                    \(dqmax\(dq: 4588,
                    \(dqcount\(dq: 2294
                },
                {
                    \(dqnumber\(dq: 3,
                    \(dqtotal\(dq: 7,
                    \(dqmin\(dq: 4589,
                    \(dqmax\(dq: 6882,
                    \(dqcount\(dq: 2294
                },
                {
                    \(dqnumber\(dq: 4,
                    \(dqtotal\(dq: 7,
                    \(dqmin\(dq: 6883,
                    \(dqmax\(dq: 9176,
                    \(dqcount\(dq: 2294
                },
                {
                    \(dqnumber\(dq: 5,
                    \(dqtotal\(dq: 7,
                    \(dqmin\(dq: 9177,
                    \(dqmax\(dq: 11470,
                    \(dqcount\(dq: 2294
                },
                {
                    \(dqnumber\(dq: 6,
                    \(dqtotal\(dq: 7,
                    \(dqmin\(dq: 11471,
                    \(dqmax\(dq: 13764,
                    \(dqcount\(dq: 2294
                },
                {
                    \(dqnumber\(dq: 7,
                    \(dqtotal\(dq: 7,
                    \(dqmin\(dq: 13765,
                    \(dqmax\(dq: 16049,
                    \(dqcount\(dq: 2285
                }
            ]
        },
        {
            \(dqoid\(dq: 317818,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqfilm\(dq,
            \(dqreltuples\(dq: 1000,
            \(dqbytes\(dq: 483328,
            \(dqbytes\-pretty\(dq: \(dq472 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic film postgres\(dq,
            \(dqpart\-key\(dq: \(dqfilm_id\(dq,
            \(dqparts\(dq: [
                {
                    \(dqnumber\(dq: 1,
                    \(dqtotal\(dq: 3,
                    \(dqmin\(dq: 1,
                    \(dqmax\(dq: 334,
                    \(dqcount\(dq: 334
                },
                {
                    \(dqnumber\(dq: 2,
                    \(dqtotal\(dq: 3,
                    \(dqmin\(dq: 335,
                    \(dqmax\(dq: 668,
                    \(dqcount\(dq: 334
                },
                {
                    \(dqnumber\(dq: 3,
                    \(dqtotal\(dq: 3,
                    \(dqmin\(dq: 669,
                    \(dqmax\(dq: 1000,
                    \(dqcount\(dq: 332
                }
            ]
        },
        {
            \(dqoid\(dq: 317920,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_04\(dq,
            \(dqreltuples\(dq: 6754,
            \(dqbytes\(dq: 434176,
            \(dqbytes\-pretty\(dq: \(dq424 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_04 postgres\(dq,
            \(dqpart\-key\(dq: \(dq\(dq
        },
        {
            \(dqoid\(dq: 317916,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_03\(dq,
            \(dqreltuples\(dq: 5644,
            \(dqbytes\(dq: 368640,
            \(dqbytes\-pretty\(dq: \(dq360 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_03 postgres\(dq,
            \(dqpart\-key\(dq: \(dq\(dq
        },
        {
            \(dqoid\(dq: 317830,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqfilm_actor\(dq,
            \(dqreltuples\(dq: 5462,
            \(dqbytes\(dq: 270336,
            \(dqbytes\-pretty\(dq: \(dq264 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic film_actor postgres\(dq,
            \(dqpart\-key\(dq: \(dq\(dq
        },
        {
            \(dqoid\(dq: 317885,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqinventory\(dq,
            \(dqreltuples\(dq: 4581,
            \(dqbytes\(dq: 270336,
            \(dqbytes\-pretty\(dq: \(dq264 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic inventory postgres\(dq,
            \(dqpart\-key\(dq: \(dqinventory_id\(dq,
            \(dqparts\(dq: [
                {
                    \(dqnumber\(dq: 1,
                    \(dqtotal\(dq: 2,
                    \(dqmin\(dq: 1,
                    \(dqmax\(dq: 2291,
                    \(dqcount\(dq: 2291
                },
                {
                    \(dqnumber\(dq: 2,
                    \(dqtotal\(dq: 2,
                    \(dqmin\(dq: 2292,
                    \(dqmax\(dq: 4581,
                    \(dqcount\(dq: 2290
                }
            ]
        },
        {
            \(dqoid\(dq: 317912,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_02\(dq,
            \(dqreltuples\(dq: 2312,
            \(dqbytes\(dq: 163840,
            \(dqbytes\-pretty\(dq: \(dq160 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_02 postgres\(dq,
            \(dqpart\-key\(dq: \(dq\(dq
        },
        {
            \(dqoid\(dq: 317784,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcustomer\(dq,
            \(dqreltuples\(dq: 599,
            \(dqbytes\(dq: 106496,
            \(dqbytes\-pretty\(dq: \(dq104 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic customer postgres\(dq,
            \(dqpart\-key\(dq: \(dqcustomer_id\(dq
        },
        {
            \(dqoid\(dq: 317845,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqaddress\(dq,
            \(dqreltuples\(dq: 603,
            \(dqbytes\(dq: 98304,
            \(dqbytes\-pretty\(dq: \(dq96 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic address postgres\(dq,
            \(dqpart\-key\(dq: \(dqaddress_id\(dq
        },
        {
            \(dqoid\(dq: 317908,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_01\(dq,
            \(dqreltuples\(dq: 1157,
            \(dqbytes\(dq: 98304,
            \(dqbytes\-pretty\(dq: \(dq96 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_01 postgres\(dq,
            \(dqpart\-key\(dq: \(dq\(dq
        },
        {
            \(dqoid\(dq: 317855,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcity\(dq,
            \(dqreltuples\(dq: 600,
            \(dqbytes\(dq: 73728,
            \(dqbytes\-pretty\(dq: \(dq72 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic city postgres\(dq,
            \(dqpart\-key\(dq: \(dqcity_id\(dq
        },
        {
            \(dqoid\(dq: 317834,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqfilm_category\(dq,
            \(dqreltuples\(dq: 1000,
            \(dqbytes\(dq: 73728,
            \(dqbytes\-pretty\(dq: \(dq72 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic film_category postgres\(dq,
            \(dqpart\-key\(dq: \(dq\(dq
        },
        {
            \(dqoid\(dq: 317798,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqactor\(dq,
            \(dqreltuples\(dq: 200,
            \(dqbytes\(dq: 49152,
            \(dqbytes\-pretty\(dq: \(dq48 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic actor postgres\(dq,
            \(dqpart\-key\(dq: \(dqactor_id\(dq
        },
        {
            \(dqoid\(dq: 317924,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_05\(dq,
            \(dqreltuples\(dq: 182,
            \(dqbytes\(dq: 40960,
            \(dqbytes\-pretty\(dq: \(dq40 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_05 postgres\(dq,
            \(dqpart\-key\(dq: \(dq\(dq
        },
        {
            \(dqoid\(dq: 317808,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcategory\(dq,
            \(dqreltuples\(dq: 0,
            \(dqbytes\(dq: 16384,
            \(dqbytes\-pretty\(dq: \(dq16 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic category postgres\(dq,
            \(dqpart\-key\(dq: \(dqcategory_id\(dq
        },
        {
            \(dqoid\(dq: 317865,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcountry\(dq,
            \(dqreltuples\(dq: 109,
            \(dqbytes\(dq: 16384,
            \(dqbytes\-pretty\(dq: \(dq16 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic country postgres\(dq,
            \(dqpart\-key\(dq: \(dqcountry_id\(dq
        },
        {
            \(dqoid\(dq: 317946,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqstaff\(dq,
            \(dqreltuples\(dq: 0,
            \(dqbytes\(dq: 16384,
            \(dqbytes\-pretty\(dq: \(dq16 kB\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic staff postgres\(dq,
            \(dqpart\-key\(dq: \(dqstaff_id\(dq
        },
        {
            \(dqoid\(dq: 378280,
            \(dqschema\(dq: \(dqpgcopydb\(dq,
            \(dqname\(dq: \(dqsentinel\(dq,
            \(dqreltuples\(dq: 1,
            \(dqbytes\(dq: 8192,
            \(dqbytes\-pretty\(dq: \(dq8192 bytes\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpgcopydb sentinel dim\(dq,
            \(dqpart\-key\(dq: \(dq\(dq
        },
        {
            \(dqoid\(dq: 317892,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqlanguage\(dq,
            \(dqreltuples\(dq: 0,
            \(dqbytes\(dq: 8192,
            \(dqbytes\-pretty\(dq: \(dq8192 bytes\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic language postgres\(dq,
            \(dqpart\-key\(dq: \(dqlanguage_id\(dq
        },
        {
            \(dqoid\(dq: 317928,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_06\(dq,
            \(dqreltuples\(dq: 0,
            \(dqbytes\(dq: 8192,
            \(dqbytes\-pretty\(dq: \(dq8192 bytes\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_06 postgres\(dq,
            \(dqpart\-key\(dq: \(dq\(dq
        },
        {
            \(dqoid\(dq: 317957,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqstore\(dq,
            \(dqreltuples\(dq: 0,
            \(dqbytes\(dq: 8192,
            \(dqbytes\-pretty\(dq: \(dq8192 bytes\(dq,
            \(dqexclude\-data\(dq: false,
            \(dqrestore\-list\-name\(dq: \(dqpublic store postgres\(dq,
            \(dqpart\-key\(dq: \(dqstore_id\(dq
        }
    ],
    \(dqindexes\(dq: [
        {
            \(dqoid\(dq: 378283,
            \(dqschema\(dq: \(dqpgcopydb\(dq,
            \(dqname\(dq: \(dqsentinel_expr_idx\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dq\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX sentinel_expr_idx ON pgcopydb.sentinel USING btree ((1))\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpgcopydb sentinel_expr_idx dim\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 378280,
                \(dqschema\(dq: \(dqpgcopydb\(dq,
                \(dqname\(dq: \(dqsentinel\(dq
            }
        },
        {
            \(dqoid\(dq: 318001,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_actor_last_name\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqlast_name\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_actor_last_name ON public.actor USING btree (last_name)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_actor_last_name postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317798,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqactor\(dq
            }
        },
        {
            \(dqoid\(dq: 317972,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqactor_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqactor_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX actor_pkey ON public.actor USING btree (actor_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317798,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqactor\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317973,
                \(dqname\(dq: \(dqactor_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (actor_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 317974,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqaddress_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqaddress_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX address_pkey ON public.address USING btree (address_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317845,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqaddress\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317975,
                \(dqname\(dq: \(dqaddress_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (address_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 318003,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_city_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcity_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_city_id ON public.address USING btree (city_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_city_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317845,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqaddress\(dq
            }
        },
        {
            \(dqoid\(dq: 317976,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcategory_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqcategory_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX category_pkey ON public.category USING btree (category_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317808,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqcategory\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317977,
                \(dqname\(dq: \(dqcategory_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (category_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 317978,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcity_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqcity_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX city_pkey ON public.city USING btree (city_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317855,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqcity\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317979,
                \(dqname\(dq: \(dqcity_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (city_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 318004,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_country_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcountry_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_country_id ON public.city USING btree (country_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_country_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317855,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqcity\(dq
            }
        },
        {
            \(dqoid\(dq: 317980,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcountry_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqcountry_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX country_pkey ON public.country USING btree (country_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317865,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqcountry\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317981,
                \(dqname\(dq: \(dqcountry_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (country_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 318024,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_last_name\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqlast_name\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_last_name ON public.customer USING btree (last_name)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_last_name postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317784,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqcustomer\(dq
            }
        },
        {
            \(dqoid\(dq: 318002,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_address_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqaddress_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_address_id ON public.customer USING btree (address_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_address_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317784,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqcustomer\(dq
            }
        },
        {
            \(dqoid\(dq: 317982,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcustomer_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX customer_pkey ON public.customer USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317784,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqcustomer\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317983,
                \(dqname\(dq: \(dqcustomer_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (customer_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 318023,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_store_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqstore_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_store_id ON public.customer USING btree (store_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_store_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317784,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqcustomer\(dq
            }
        },
        {
            \(dqoid\(dq: 318009,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_original_language_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqoriginal_language_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_original_language_id ON public.film USING btree (original_language_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_original_language_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317818,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqfilm\(dq
            }
        },
        {
            \(dqoid\(dq: 318026,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_title\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqtitle\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_title ON public.film USING btree (title)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_title postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317818,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqfilm\(dq
            }
        },
        {
            \(dqoid\(dq: 318000,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqfilm_fulltext_idx\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqfulltext\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX film_fulltext_idx ON public.film USING gist (fulltext)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic film_fulltext_idx postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317818,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqfilm\(dq
            }
        },
        {
            \(dqoid\(dq: 317988,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqfilm_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqfilm_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX film_pkey ON public.film USING btree (film_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317818,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqfilm\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317989,
                \(dqname\(dq: \(dqfilm_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (film_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 318008,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_language_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqlanguage_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_language_id ON public.film USING btree (language_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_language_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317818,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqfilm\(dq
            }
        },
        {
            \(dqoid\(dq: 317984,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqfilm_actor_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqactor_id,film_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX film_actor_pkey ON public.film_actor USING btree (actor_id, film_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317830,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqfilm_actor\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317985,
                \(dqname\(dq: \(dqfilm_actor_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (actor_id, film_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 318006,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_film_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqfilm_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_film_id ON public.film_actor USING btree (film_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_film_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317830,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqfilm_actor\(dq
            }
        },
        {
            \(dqoid\(dq: 317986,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqfilm_category_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqfilm_id,category_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX film_category_pkey ON public.film_category USING btree (film_id, category_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317834,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqfilm_category\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317987,
                \(dqname\(dq: \(dqfilm_category_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (film_id, category_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 318025,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_store_id_film_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqfilm_id,store_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_store_id_film_id ON public.inventory USING btree (store_id, film_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_store_id_film_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317885,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqinventory\(dq
            }
        },
        {
            \(dqoid\(dq: 317990,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqinventory_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqinventory_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX inventory_pkey ON public.inventory USING btree (inventory_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317885,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqinventory\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317991,
                \(dqname\(dq: \(dqinventory_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (inventory_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 317992,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqlanguage_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqlanguage_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX language_pkey ON public.language USING btree (language_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317892,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqlanguage\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317993,
                \(dqname\(dq: \(dqlanguage_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (language_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 318010,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_01_customer_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_01_customer_id ON public.payment_p2020_01 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_01_customer_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317908,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_01\(dq
            }
        },
        {
            \(dqoid\(dq: 318029,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_01_customer_id_idx\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX payment_p2020_01_customer_id_idx ON public.payment_p2020_01 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_01_customer_id_idx postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317908,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_01\(dq
            }
        },
        {
            \(dqoid\(dq: 318012,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_01_staff_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqstaff_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_01_staff_id ON public.payment_p2020_01 USING btree (staff_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_01_staff_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317908,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_01\(dq
            }
        },
        {
            \(dqoid\(dq: 318013,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_02_customer_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_02_customer_id ON public.payment_p2020_02 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_02_customer_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317912,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_02\(dq
            }
        },
        {
            \(dqoid\(dq: 318014,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_02_staff_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqstaff_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_02_staff_id ON public.payment_p2020_02 USING btree (staff_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_02_staff_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317912,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_02\(dq
            }
        },
        {
            \(dqoid\(dq: 318030,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_02_customer_id_idx\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX payment_p2020_02_customer_id_idx ON public.payment_p2020_02 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_02_customer_id_idx postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317912,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_02\(dq
            }
        },
        {
            \(dqoid\(dq: 318016,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_03_staff_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqstaff_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_03_staff_id ON public.payment_p2020_03 USING btree (staff_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_03_staff_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317916,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_03\(dq
            }
        },
        {
            \(dqoid\(dq: 318031,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_03_customer_id_idx\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX payment_p2020_03_customer_id_idx ON public.payment_p2020_03 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_03_customer_id_idx postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317916,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_03\(dq
            }
        },
        {
            \(dqoid\(dq: 318015,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_03_customer_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_03_customer_id ON public.payment_p2020_03 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_03_customer_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317916,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_03\(dq
            }
        },
        {
            \(dqoid\(dq: 318032,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_04_customer_id_idx\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX payment_p2020_04_customer_id_idx ON public.payment_p2020_04 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_04_customer_id_idx postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317920,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_04\(dq
            }
        },
        {
            \(dqoid\(dq: 318018,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_04_staff_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqstaff_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_04_staff_id ON public.payment_p2020_04 USING btree (staff_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_04_staff_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317920,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_04\(dq
            }
        },
        {
            \(dqoid\(dq: 318017,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_04_customer_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_04_customer_id ON public.payment_p2020_04 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_04_customer_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317920,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_04\(dq
            }
        },
        {
            \(dqoid\(dq: 318019,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_05_customer_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_05_customer_id ON public.payment_p2020_05 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_05_customer_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317924,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_05\(dq
            }
        },
        {
            \(dqoid\(dq: 318020,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_05_staff_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqstaff_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_05_staff_id ON public.payment_p2020_05 USING btree (staff_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_05_staff_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317924,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_05\(dq
            }
        },
        {
            \(dqoid\(dq: 318033,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_05_customer_id_idx\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX payment_p2020_05_customer_id_idx ON public.payment_p2020_05 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_05_customer_id_idx postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317924,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_05\(dq
            }
        },
        {
            \(dqoid\(dq: 318022,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_06_staff_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqstaff_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_06_staff_id ON public.payment_p2020_06 USING btree (staff_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_06_staff_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317928,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_06\(dq
            }
        },
        {
            \(dqoid\(dq: 318034,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_p2020_06_customer_id_idx\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX payment_p2020_06_customer_id_idx ON public.payment_p2020_06 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_06_customer_id_idx postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317928,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_06\(dq
            }
        },
        {
            \(dqoid\(dq: 318021,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_payment_p2020_06_customer_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqcustomer_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_payment_p2020_06_customer_id ON public.payment_p2020_06 USING btree (customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_payment_p2020_06_customer_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317928,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_06\(dq
            }
        },
        {
            \(dqoid\(dq: 318028,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_unq_rental_rental_date_inventory_id_customer_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqrental_date,inventory_id,customer_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX idx_unq_rental_rental_date_inventory_id_customer_id ON public.rental USING btree (rental_date, inventory_id, customer_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_unq_rental_rental_date_inventory_id_customer_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317934,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqrental\(dq
            }
        },
        {
            \(dqoid\(dq: 317994,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqrental_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqrental_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX rental_pkey ON public.rental USING btree (rental_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317934,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqrental\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317995,
                \(dqname\(dq: \(dqrental_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (rental_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 318007,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_fk_inventory_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: false,
            \(dqcolumns\(dq: \(dqinventory_id\(dq,
            \(dqsql\(dq: \(dqCREATE INDEX idx_fk_inventory_id ON public.rental USING btree (inventory_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_fk_inventory_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317934,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqrental\(dq
            }
        },
        {
            \(dqoid\(dq: 317996,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqstaff_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqstaff_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX staff_pkey ON public.staff USING btree (staff_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317946,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqstaff\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317997,
                \(dqname\(dq: \(dqstaff_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (staff_id)\(dq
            }
        },
        {
            \(dqoid\(dq: 318027,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqidx_unq_manager_staff_id\(dq,
            \(dqisPrimary\(dq: false,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqmanager_staff_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX idx_unq_manager_staff_id ON public.store USING btree (manager_staff_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dqpublic idx_unq_manager_staff_id postgres\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317957,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqstore\(dq
            }
        },
        {
            \(dqoid\(dq: 317998,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqstore_pkey\(dq,
            \(dqisPrimary\(dq: true,
            \(dqisUnique\(dq: true,
            \(dqcolumns\(dq: \(dqstore_id\(dq,
            \(dqsql\(dq: \(dqCREATE UNIQUE INDEX store_pkey ON public.store USING btree (store_id)\(dq,
            \(dqrestore\-list\-name\(dq: \(dq\(dq,
            \(dqtable\(dq: {
                \(dqoid\(dq: 317957,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqstore\(dq
            },
            \(dqconstraint\(dq: {
                \(dqoid\(dq: 317999,
                \(dqname\(dq: \(dqstore_pkey\(dq,
                \(dqsql\(dq: \(dqPRIMARY KEY (store_id)\(dq
            }
        }
    ],
    \(dqsequences\(dq: [
        {
            \(dqoid\(dq: 317796,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqactor_actor_id_seq\(dq,
            \(dqlast\-value\(dq: 200,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic actor_actor_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317843,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqaddress_address_id_seq\(dq,
            \(dqlast\-value\(dq: 605,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic address_address_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317806,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcategory_category_id_seq\(dq,
            \(dqlast\-value\(dq: 16,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic category_category_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317853,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcity_city_id_seq\(dq,
            \(dqlast\-value\(dq: 600,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic city_city_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317863,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcountry_country_id_seq\(dq,
            \(dqlast\-value\(dq: 109,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic country_country_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317782,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqcustomer_customer_id_seq\(dq,
            \(dqlast\-value\(dq: 599,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic customer_customer_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317816,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqfilm_film_id_seq\(dq,
            \(dqlast\-value\(dq: 1000,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic film_film_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317883,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqinventory_inventory_id_seq\(dq,
            \(dqlast\-value\(dq: 4581,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic inventory_inventory_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317890,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqlanguage_language_id_seq\(dq,
            \(dqlast\-value\(dq: 6,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic language_language_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317902,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqpayment_payment_id_seq\(dq,
            \(dqlast\-value\(dq: 32099,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic payment_payment_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317932,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqrental_rental_id_seq\(dq,
            \(dqlast\-value\(dq: 16050,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic rental_rental_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317944,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqstaff_staff_id_seq\(dq,
            \(dqlast\-value\(dq: 2,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic staff_staff_id_seq postgres\(dq
        },
        {
            \(dqoid\(dq: 317955,
            \(dqschema\(dq: \(dqpublic\(dq,
            \(dqname\(dq: \(dqstore_store_id_seq\(dq,
            \(dqlast\-value\(dq: 2,
            \(dqis\-called\(dq: true,
            \(dqrestore\-list\-name\(dq: \(dqpublic store_store_id_seq postgres\(dq
        }
    ]
}
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
Listing current progress (log lines removed):
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
$ pgcopydb list progress 2>/dev/null
             |  Total Count |  In Progress |         Done
\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-
      Tables |           21 |            4 |            7
     Indexes |           48 |           14 |            7
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
Listing current progress, in JSON:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
$ pgcopydb list progress \-\-json 2>/dev/null
{
    \(dqtable\-jobs\(dq: 4,
    \(dqindex\-jobs\(dq: 4,
    \(dqtables\(dq: {
        \(dqtotal\(dq: 21,
        \(dqdone\(dq: 9,
        \(dqin\-progress\(dq: [
            {
                \(dqoid\(dq: 317908,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqpayment_p2020_01\(dq,
                \(dqreltuples\(dq: 1157,
                \(dqbytes\(dq: 98304,
                \(dqbytes\-pretty\(dq: \(dq96 kB\(dq,
                \(dqexclude\-data\(dq: false,
                \(dqrestore\-list\-name\(dq: \(dqpublic payment_p2020_01 postgres\(dq,
                \(dqpart\-key\(dq: \(dq\(dq,
                \(dqprocess\(dq: {
                    \(dqpid\(dq: 75159,
                    \(dqstart\-time\-epoch\(dq: 1662476249,
                    \(dqstart\-time\-string\(dq: \(dq2022\-09\-06 16:57:29 CEST\(dq,
                    \(dqcommand\(dq: \(dqCOPY \e\(dqpublic\e\(dq.\e\(dqpayment_p2020_01\e\(dq\(dq
                }
            },
            {
                \(dqoid\(dq: 317855,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqcity\(dq,
                \(dqreltuples\(dq: 600,
                \(dqbytes\(dq: 73728,
                \(dqbytes\-pretty\(dq: \(dq72 kB\(dq,
                \(dqexclude\-data\(dq: false,
                \(dqrestore\-list\-name\(dq: \(dqpublic city postgres\(dq,
                \(dqpart\-key\(dq: \(dqcity_id\(dq,
                \(dqprocess\(dq: {
                    \(dqpid\(dq: 75157,
                    \(dqstart\-time\-epoch\(dq: 1662476249,
                    \(dqstart\-time\-string\(dq: \(dq2022\-09\-06 16:57:29 CEST\(dq,
                    \(dqcommand\(dq: \(dqCOPY \e\(dqpublic\e\(dq.\e\(dqcity\e\(dq\(dq
                }
            }
        ]
    },
       \(dqindexes\(dq: {
        \(dqtotal\(dq: 48,
        \(dqdone\(dq: 39,
        \(dqin\-progress\(dq: [
            {
                \(dqoid\(dq: 378283,
                \(dqschema\(dq: \(dqpgcopydb\(dq,
                \(dqname\(dq: \(dqsentinel_expr_idx\(dq,
                \(dqisPrimary\(dq: false,
                \(dqisUnique\(dq: true,
                \(dqcolumns\(dq: \(dq\(dq,
                \(dqsql\(dq: \(dqCREATE UNIQUE INDEX sentinel_expr_idx ON pgcopydb.sentinel USING btree ((1))\(dq,
                \(dqrestore\-list\-name\(dq: \(dqpgcopydb sentinel_expr_idx dim\(dq,
                \(dqtable\(dq: {
                    \(dqoid\(dq: 378280,
                    \(dqschema\(dq: \(dqpgcopydb\(dq,
                    \(dqname\(dq: \(dqsentinel\(dq
                },
                \(dqprocess\(dq: {
                    \(dqpid\(dq: 74372,
                    \(dqstart\-time\-epoch\(dq: 1662476080,
                    \(dqstart\-time\-string\(dq: \(dq2022\-09\-06 16:54:40 CEST\(dq
                }
            },
            {
                \(dqoid\(dq: 317980,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqcountry_pkey\(dq,
                \(dqisPrimary\(dq: true,
                \(dqisUnique\(dq: true,
                \(dqcolumns\(dq: \(dqcountry_id\(dq,
                \(dqsql\(dq: \(dqCREATE UNIQUE INDEX country_pkey ON public.country USING btree (country_id)\(dq,
                \(dqrestore\-list\-name\(dq: \(dqpublic country_pkey postgres\(dq,
                \(dqtable\(dq: {
                    \(dqoid\(dq: 317865,
                    \(dqschema\(dq: \(dqpublic\(dq,
                    \(dqname\(dq: \(dqcountry\(dq
                },
                \(dqconstraint\(dq: {
                    \(dqoid\(dq: 317981,
                    \(dqname\(dq: \(dqcountry_pkey\(dq,
                    \(dqsql\(dq: \(dqPRIMARY KEY (country_id)\(dq,
                    \(dqrestore\-list\-name\(dq: \(dq\(dq
                },
                \(dqprocess\(dq: {
                    \(dqpid\(dq: 74358,
                    \(dqstart\-time\-epoch\(dq: 1662476080,
                    \(dqstart\-time\-string\(dq: \(dq2022\-09\-06 16:54:40 CEST\(dq
                }
            },
            {
                \(dqoid\(dq: 317996,
                \(dqschema\(dq: \(dqpublic\(dq,
                \(dqname\(dq: \(dqstaff_pkey\(dq,
                \(dqisPrimary\(dq: true,
                \(dqisUnique\(dq: true,
                \(dqcolumns\(dq: \(dqstaff_id\(dq,
                \(dqsql\(dq: \(dqCREATE UNIQUE INDEX staff_pkey ON public.staff USING btree (staff_id)\(dq,
                \(dqrestore\-list\-name\(dq: \(dqpublic staff_pkey postgres\(dq,
                \(dqtable\(dq: {
                    \(dqoid\(dq: 317946,
                    \(dqschema\(dq: \(dqpublic\(dq,
                    \(dqname\(dq: \(dqstaff\(dq
                },
                \(dqconstraint\(dq: {
                    \(dqoid\(dq: 317997,
                    \(dqname\(dq: \(dqstaff_pkey\(dq,
                    \(dqsql\(dq: \(dqPRIMARY KEY (staff_id)\(dq,
                    \(dqrestore\-list\-name\(dq: \(dq\(dq
                },
                \(dqprocess\(dq: {
                    \(dqpid\(dq: 74368,
                    \(dqstart\-time\-epoch\(dq: 1662476080,
                    \(dqstart\-time\-string\(dq: \(dq2022\-09\-06 16:54:40 CEST\(dq
                }
            }
        ]
    }
}
.ft P
.fi
.UNINDENT
.UNINDENT
.SH AUTHOR
Dimitri Fontaine
.SH COPYRIGHT
2023, Dimitri Fontaine
.\" Generated by docutils manpage writer.
.