sslug-teknik team mailing list archive

[Kim Nielsen <knielsen@xxxxxxxxxxxxxxxxxxxxxxx>]

Kim Nielsen wrote:

[En masse hø]


Igen finder jeg selv en løsning takket være opensource :) og svaret var



SELECT a.attnum, a.attname AS field, t.typname AS type, a.attlen AS 
length, a.atttypmod AS lengthvar, a.attnotnull AS notnull FROM pg_class 
c, pg_attribute a, pg_type t WHERE c.relname = 'crm_pipeline' and 
a.attnum > 0 and a.attrelid = c.oid and a.atttypid = t.oid ORDER BY a.attnum

/Kim