pgdump

Documentation

Index

• func DumpData(ctx context.Context, conn pgd.DBTX, out io.Writer, skipTables []string) error
• func DumpDataWithSchema(ctx context.Context, conn pgd.DBTX, out io.Writer, skipTables []string, ...) error
• func DumpDataWithSchemaParallel(ctx context.Context, conn *pgxpool.Pool, out io.Writer, skipTables []string, ...) error
• type Column
  • func (c Column) EntityName() string
  • func (c Column) String() string
• type Constraint
  • func (c Constraint) EntityName() string
  • func (c Constraint) String() string
• type Enum
  • func (e Enum) EntityName() string
  • func (e Enum) String() string
• type Extension
  • func (e Extension) EntityName() string
  • func (e Extension) String() string
• type Function
  • func (f Function) EntityName() string
  • func (f Function) String() string
• type Index
  • func (idx Index) EntityName() string
  • func (idx Index) String() string
• type Schema
  • func DumpSchema(ctx context.Context, conn pgd.DBTX) (*Schema, error)
  • func (s Schema) String() string
• type Sequence
  • func (s Sequence) EntityName() string
  • func (s Sequence) String() string
• type Table
  • func (t Table) EntityName() string
  • func (t Table) String() string
• type TableData
• type Trigger
  • func (t Trigger) EntityName() string
  • func (t Trigger) String() string

Functions

func DumpData

func DumpData(ctx context.Context, conn pgd.DBTX, out io.Writer, skipTables []string) error

func DumpDataWithSchema

func DumpDataWithSchema(ctx context.Context, conn pgd.DBTX, out io.Writer, skipTables []string, schema *Schema) error

DumpDataWithSchema will return all data from all tables (except those in skipTables) in a structured format.

func DumpDataWithSchemaParallel

func DumpDataWithSchemaParallel(ctx context.Context, conn *pgxpool.Pool, out io.Writer, skipTables []string, schema *Schema) error

DumpDataWithSchema will return all data from all tables (except those in skipTables) in a structured format.

Types

type Column

type Column struct {
	Name         string
	Type         string
	NotNull      bool
	DefaultValue string
}

func (Column) EntityName

func (c Column) EntityName() string

func (Column) String

func (c Column) String() string

type Constraint

type Constraint struct {
	Name string
	Def  string
}

func (Constraint) EntityName

func (c Constraint) EntityName() string

func (Constraint) String

func (c Constraint) String() string

type Enum

type Enum struct {
	Name   string
	Values []string
}

func (Enum) EntityName

func (e Enum) EntityName() string

func (Enum) String

func (e Enum) String() string

type Extension

type Extension struct {
	Name string
}

func (Extension) EntityName

func (e Extension) EntityName() string

func (Extension) String

func (e Extension) String() string

type Function

type Function struct {
	Name string
	Def  string
}

func (Function) EntityName

func (f Function) EntityName() string

func (Function) String

func (f Function) String() string

type Index

type Index struct {
	Name string
	Def  string
}

func (Index) EntityName

func (idx Index) EntityName() string

func (Index) String

func (idx Index) String() string

type Schema

type Schema struct {
	Extensions []Extension
	Functions  []Function
	Tables     []Table
	Enums      []Enum
	Sequences  []Sequence
}

func DumpSchema

func DumpSchema(ctx context.Context, conn pgd.DBTX) (*Schema, error)

func (Schema) String

func (s Schema) String() string

type Sequence

type Sequence struct {
	Name       string
	StartValue int64
	Increment  int64
	MinValue   int64
	MaxValue   int64
	Cache      int64

	OwnedBy string
}

func (Sequence) EntityName

func (s Sequence) EntityName() string

func (Sequence) String

func (s Sequence) String() string

type Table

type Table struct {
	Name string

	Columns     []Column
	Constraints []Constraint
	Indexes     []Index
	Triggers    []Trigger
	Sequences   []Sequence
}

func (Table) EntityName

func (t Table) EntityName() string

func (Table) String

func (t Table) String() string

type TableData

type TableData struct {
	TableName string
	Columns   []string
	Rows      [][]string
}

type Trigger

type Trigger struct {
	Name string
	Def  string
}

func (Trigger) EntityName

func (t Trigger) EntityName() string

func (Trigger) String

func (t Trigger) String() string