Here it is

                                Table "public.user
info"
      Column      |             Type              
| Modifiers | Storage  | Description 
------------------+-------------------------------
+-----------+----------+-------------
 uid              | integer                       
| not null  | plain    | 
 screen_name      | character varying             
| not null  | extended | 
 user_name        | character varying             
| not null  | extended | 
 location         | character varying             
|           | extended | 
 user_language    | character varying             
|           | extended | 
 favourites_count | integer                       |           | plain
    | 
 followers_count  | integer                       |           | plain
    | 
 friends_count    | integer                       |           | plain
    | 
 status_count     | integer                       |           | plain
    | 
 listed_count     | integer                       |           | plain
    | 
 created_at       | character varying             |           | exten
ded | 
 time_zone        | character varying             |           | exten
ded | 
 user_url         | character varying             |           | exten
ded | 
 description      | text[]                        |           | exten
ded | 
 added_on         | timestamp without time zone[] |           | exten
ded | 
Indexes:
    "pk_user" PRIMARY KEY, btree (uid)
Rules:
    my_table_on_duplicate_ignore AS
    ON INSERT TO userinfo
   WHERE (EXISTS ( SELECT 1
           FROM userinfo
          WHERE userinfo.uid = new.uid)) DO INSTEAD NOTHING
Has OIDs: no

[download]
Maybe the problem is the brackets after the text type? Those were inserted when I created the column with pgadminIII.

In reply to Re^4: PgPP invalid byte seqnence for encoding UTF8 by cormanaz
in thread PgPP invalid byte seqnence for encoding UTF8 by cormanaz

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.