Text Size: Normal / Large

6.3. Example

The following sequence of commands will create the test_table table with the two columns cola and colb of type int4 and text, respectively, and insert two rows into the table.

create test_table (cola = int4, colb = text)
 open test_table
 insert OID=421 ( 1 "value1" )
 insert OID=422 ( 2 _null_ )
 close test_table

Privacy Policy | Project hosted by our server sponsors. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group