สล็อต pg Options
สล็อต pg Options
Blog Article
Specifies a job name for use to make the dump. This option will cause pg_dump to situation a established ROLE rolename
In the situation of a parallel dump, the snapshot name described by this feature is applied สล็อตออนไลน์ instead of having a completely new snapshot.
parameter is interpreted to be a sample based on the identical policies employed by psql's \d commands (see styles), so many schemas can also be chosen by creating wildcard figures within the pattern.
With zstd compression, very long mode may Increase the compression ratio, at the price of elevated memory use.
this feature disables the usage of dollar quoting for functionality bodies, and forces them being quoted utilizing SQL conventional string syntax.
Dump data as INSERT commands (as an alternative to COPY). Controls the maximum range of rows for every INSERT command. The value specified need to be a number bigger than zero. Any error through restoring will lead to only rows that are Element of the problematic INSERT for being misplaced, rather than the complete desk contents.
When utilizing wildcards, be cautious to estimate the pattern if wanted to circumvent the shell from growing the wildcards; see illustrations underneath. the one exception is the fact that an vacant pattern is disallowed.
. The sample is interpreted in accordance with the very same principles as for -t. --exclude-table-details is usually offered much more than when to exclude tables matching any of several styles. this feature is useful when you want the definition of a selected table While you don't need to have the data in it.
this feature is relevant only when developing a information-only dump. It instructs pg_dump to incorporate commands to temporarily disable triggers on the focus on tables although the data is restored.
build the dump in the desired character set encoding. By default, the dump is made within the database encoding. (yet another way to get the exact result is to established the PGCLIENTENCODING ecosystem variable to the specified dump encoding.) The supported encodings are explained in segment 24.3.1.
This may be useful when restoring details on the server where rows tend not to always drop into the identical partitions because they did on the original server. that can happen, by way of example, In the event the partitioning column is of kind text and the two devices have various definitions in the collation used to form the partitioning column.
usually do not output instructions to pick table entry procedures. With this option, all objects will likely be established with whichever desk obtain system may be the default for the duration of restore.
Should the user doesn't have ample privileges to bypass row stability, then an error is thrown. This parameter instructs pg_dump to established row_security to on as a substitute, allowing the consumer to dump the elements of the contents on the desk that they may have use of.
If the databases cluster has any area additions to the template1 databases, be mindful to restore the output of pg_dump into A very empty database; usually that you are very likely to get mistakes because of duplicate definitions in the included objects.
to the personalized and Listing archive formats, this specifies compression of unique table-information segments, as well as the default is usually to compress employing gzip at a average stage. For simple text output, environment a nonzero compression degree results in all the output file to be compressed, as though it had been fed as a result of gzip, lz4, or zstd; even so the default is not to compress.
this selection is rarely crucial, because pg_dump will mechanically prompt to get a password If your server calls for password authentication.
Report this page