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

In This Topic
    PgSqlDump Class Members
    In This Topic

    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 PropertyGets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (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 PropertyGets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (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 MethodCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
    Public MethodReleases all resources used by the System.ComponentModel.Component. (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 MethodRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodServes to import database dump from the file for further execution of the Restore method.  
    Public MethodObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodOverloaded. Executes script specified in the Devart.Common.DbDump descendant property. (Inherited from Devart.Common.DbDump)
    Public MethodReturns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component)
    Top
    Public Events
     NameDescription
    Public EventOccurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (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