Table creation: Difference between revisions

Content added Content deleted

Inline

@@ Line 25: / Line 25: @@
  );
-bool: 't', 'f' or NULL
+ -- bool: 't', 'f' or NULL
-int2: -32768 to +32767
+ -- int2: -32768 to +32767
-int4: -2147483648 to +2147483647
+ -- int4: -2147483648 to +2147483647
-float: decimal
+ -- float: decimal
-date: obvious
+ -- date: obvious
-timestamp: date time
+ -- timestamp: date time
-char(#): space padded text field with length of #
+ -- char(#): space padded text field with length of #
-varchar(#): variable length text field up to #
+ -- varchar(#): variable length text field up to #
-text: not limited
+ -- text: not limited