baruwa=> \d messages
Table "public.messages"
Column | Type | Modifiers
---------------+--------------------------+-------------------------------------------------------
id | bigint | not null default
nextval('messages_id_seq'::regclass)
messageid | character varying(255) |
actions | character varying(128) |
clientip | character varying(128) |
date | date |
from_address | character varying(255) |
from_domain | character varying(255) |
headers | text |
hostname | text |
highspam | smallint |
rblspam | smallint |
saspam | smallint |
spam | smallint |
nameinfected | smallint |
otherinfected | smallint |
isquarantined | smallint |
isarchived | smallint |
sascore | double precision |
scaned | smallint |
size | integer |
blacklisted | smallint |
spamreport | text |
whitelisted | smallint |
subject | text |
time | time with time zone |
timestamp | timestamp with time zone | default timezone('utc'::text, now())
to_address | character varying(255) |
to_domain | character varying(255) |
virusinfected | smallint |
ts | timestamp with time zone | default timezone('utc'::text, now())
Anyway to show a test insert, not sure which of the varying(255) it is saying
is too long .
--
Jeremy McSpadden
Flux Labs | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless
Solutions
Office : 850-250-5590x101<tel:850-250-5590;101> | Cell :
850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955>
_______________________________________________
http://pledgie.com/campaigns/12056
_______________________________________________
http://pledgie.com/campaigns/12056
