dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlDump Class
Properties Methods Events

PgSqlDump Class Members

The following tables list the members exposed by PgSqlDump.

Public Constructors
 NameDescription
Public ConstructorOverloaded. Initializes a new instance of the PgSqlDump class.  
Top
Public Properties
 NameDescription
Public PropertyGets or sets the size of a data block for reading from the large object and dumping to a single INSERT statement (SELECT LOWRITE...). Default value is 0 (large objects will not be split when dumping).  
Public PropertyGets or sets the max size in bytes of a single insert statement with multiple values in the script. Ignored if UseMultirowSyntax is set to false.  
Public PropertyGets or sets the PgSqlConnection used by this instance of the PgSqlDump.  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyGets or sets a value that determines whether to add statements that create table constraints in the dump.  
Public PropertyOverridden. Gets as a result of Backup() execution, or sets data needed to execute Restore() method.  
Public PropertyGets or sets a value that determines whether to add some extra information in the script header. (Inherited from Devart.Common.DbDump)
Public PropertyInclude large objects, associated with Oid filed values of dumped tables, in the dump.  
Public PropertyDetermines whether to recreate database objects. (Inherited from Devart.Common.DbDump)
Public PropertyDetermines whether to include tablespaces into the dump script.  
Public PropertyDetermines whether to include information about users into the dump text.  
Public PropertyDetermines whether to include data from tables into the dump text, script to create database objects or both. (Inherited from Devart.Common.DbDump)
Public PropertyGets or sets a value that indicates which objects will be included in the dump.  
Public PropertyDetermines whether to quote all identifiers present in the database. (Inherited from Devart.Common.DbDump)
Public PropertySpecifies server schema that will be dumped.  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyOverridden. Gets or sets a list of the tables which will be used in the script. Table names are separated by semicolon.  
Public PropertyDetermines whether to use the multirow VALUES syntax when generating INSERT statements.  
Top
Public Methods
 NameDescription
Public MethodOverloaded. Generates a script and writes it to the DumpText property. (Inherited from Devart.Common.DbDump)
Public MethodOverloaded. Generates a script with a backup of the data, returned by the specified query, and writes it to the DumpText property. (Inherited from Devart.Common.DbDump)
Public MethodOverloaded. Starts an asynchronous invocation of a Backup method. (Inherited from Devart.Common.DbDump)
Public MethodOverloaded. Starts an asynchronous invocation of a BackupQuery(String) method. (Inherited from Devart.Common.DbDump)
Public MethodOverloaded. Starts an asynchronous invocation of a Restore method. (Inherited from Devart.Common.DbDump)
Public Method (Inherited from System.MarshalByRefObject)
Public Method (Inherited from System.ComponentModel.Component)
Public MethodEnds an asynchronous invocation of the Backup method. (Inherited from Devart.Common.DbDump)
Public MethodEnds an asynchronous invocation of the BackupQuery method. (Inherited from Devart.Common.DbDump)
Public MethodEnds an asynchronous invocation of the Restore method. (Inherited from Devart.Common.DbDump)
Public MethodServes to store dump text into the file.  
Public Method (Inherited from System.MarshalByRefObject)
Public MethodServes to import database dump from the file for further execution of the Restore method.  
Public Method (Inherited from System.MarshalByRefObject)
Public MethodOverloaded. Executes script specified in the Devart.Common.DbDump descendant property. (Inherited from Devart.Common.DbDump)
Public Method (Inherited from System.ComponentModel.Component)
Top
Public Events
 NameDescription
Public Event (Inherited from System.ComponentModel.Component)
Public EventOccurs when a SQL statement within the script is about to execute. You can use this event to track the progress of the restore integration.  
Top
See Also