User defined columns in Postgres

[shinji62]

Hi,

It seems that user-defined columns are not support in postgres dialect. can be noice if xorg can support it
because I can not backup my database with it.

[xorm] [info]  2015/06/14 17:42:33.719688 [sql] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, numeric_precision, numeric_precision_radix ,
    CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
    CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
    JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
    LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
    LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
    LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
    LEFT JOIN pg_class AS g ON p.confrelid = g.oid
    LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE c.relkind = 'r'::char AND c.relname = $1 AND f.attnum > 0 ORDER BY f.attnum; [billing_events]
[xorm] [info]  2015/06/14 17:42:33.721043 [sql] SELECT indexname, indexdef FROM pg_indexes WHERE schemaname='public' AND tablename=$1 [billing_events]
[xorm] [info]  2015/06/14 17:42:33.725083 [sql] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, numeric_precision, numeric_precision_radix ,
    CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
    CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
    JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
    LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
    LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
    LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
    LEFT JOIN pg_class AS g ON p.confrelid = g.oid
    LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE c.relkind = 'r'::char AND c.relname = $1 AND f.attnum > 0 ORDER BY f.attnum; [service_auth_tokens]
2015/06/14 17:42:33 Error during Backup Postgres:  unkonw colType USER-DEFINED

Thanks

[lunny]

Yes, it's still not defined.

[shinji62]

Can you prioritize it ?

[lunny]

OKay. I will learn postgres USER-DEFINED feature first. Any document do you know about that?

[shinji62]

http://www.sqlines.com/postgresql/how-to/create_user_defined_type