postgres

package

v1.0.0 Latest Latest Go to latest Published: Aug 3, 2026 License: MIT Imports: 5 Imported by: 0

Details

Package postgres provides the PostgreSQL dialect for dbmigrate.

This section is empty.

This section is empty.

func Open(dsn string) (*sql.DB, error)

Open returns an *sql.DB for the given Postgres DSN using pgx.

func QuoteIdentifier(s string) string

QuoteIdentifier quotes a Postgres identifier defensively.

type PostgresDialect struct {
	// contains filtered or unexported fields
}

PostgresDialect implements dbmigrate.Dialect for PostgreSQL.

func Dialect() *PostgresDialect

Dialect returns the PostgreSQL dialect for dbmigrate.

func (p *PostgresDialect) DropTableSQL(schema, table string) string

DropTableSQL returns SQL to drop a table in a schema with CASCADE.

func (p *PostgresDialect) EnsureTableSQL(tableName string) string

EnsureTableSQL returns the CREATE TABLE statement for the tracking table.

func (p *PostgresDialect) ListTablesSQL() string

ListTablesSQL returns the query used by Fresh to list user tables.

func (p *PostgresDialect) Lock(ctx context.Context, db *sql.DB) (func() error, error)

Lock uses pg_advisory_lock on a dedicated connection.

func (p *PostgresDialect) Name() string

Name returns the dialect name.

func (d *PostgresDialect) QuoteIdentifier(s string) string

QuoteIdentifier quotes an identifier with double quotes.

func (p *PostgresDialect) TimestampDefault() string

TimestampDefault returns the Postgres current-timestamp expression.