Skip to content

Option to import as text instead of varchar with specific size #21

@geraldodev

Description

@geraldodev

Use case:

Imported tables cannot be inherit from common table due to difference of varchar column length.

Tip from http://www.postgresql.org/docs/9.1/static/datatype-character.html

"There is no performance difference among these three types, apart from increased storage space when using the blank-padded type, and a few extra CPU cycles to check the length when storing into a length-constrained column. While character(n) has performance advantages in some other database systems, there is no such advantage in PostgreSQL; in fact character(n) is usually the slowest of the three because of its additional storage costs. In most situations text or character varying should be used instead."

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions