But double offers are Distinctive to your shell, so consequently they must be quoted. Thus, to dump a single desk with a combined-scenario name, you need anything like

never ever has the teenager Motion picture genre been additional Energetic than it can be right now. Seemingly each individual weekend, there's a new entry, as well as the strong box Office environment general performance assures that there'll be lots of extra to come. A craze with new teen films continues to be to recycle ...

parameter is interpreted like a sample according to the exact policies employed by psql's \d commands (see Patterns), so multiple schemas can also be selected by crafting wildcard figures during the sample.

Specifies the host name of the device on which the server is jogging. If the value starts using a slash, it's used since the directory for that Unix area socket. The default is taken with the PGHOST setting variable, if established, else a Unix domain socket connection is attempted.

this feature disables the use of greenback quoting for functionality bodies, and forces them to become quoted making use of SQL typical string syntax.

Output SQL-conventional established SESSION AUTHORIZATION instructions as opposed to ALTER operator instructions to find out object ownership. This helps make the dump additional specifications-appropriate, but with regards to the historical past from the objects from the dump, might not restore properly.

This option is useful when needing to synchronize the dump by using a logical replication slot (see Chapter 49) or having a concurrent session.

Output instructions to DROP all of the dumped database objects ahead of outputting the commands for developing them. this feature is helpful in the event the restore is usually to overwrite an current databases.

. The pattern is interpreted based on the exact rules as for -t. -T may be presented greater than after to exclude tables matching any of several patterns.

generate the dump in the desired character established encoding. By default, the dump is established in the database encoding. (yet another way to get the very same result's to set the PGCLIENTENCODING setting variable to the specified dump encoding.) The supported encodings are explained in portion 24.three.1.

tables concurrently. this selection may สล็อตทดลอง possibly lessen the time needed to carry out the dump but In addition it boosts the load about the database server.

This is often the same as the -t/--desk alternative, except that In addition it includes any partitions or inheritance little one tables in the table(s) matching the sample

When making use of wildcards, be mindful to quotation the pattern if required to forestall the shell from growing the wildcards; see Examples below.

Use this When you've got referential integrity checks or other triggers on the tables that you don't want to invoke during information restore.

Some installations Use a plan versus logging in straight as a superuser, and use of this selection will allow dumps being created without violating the plan.

When utilizing wildcards, be careful to quotation the sample if necessary to forestall the shell from expanding the wildcards; see illustrations underneath.