On 01/22/2015 06:54 AM, Pierre Hsieh wrote:
Hi, Is there anyone who can help me to create a specific table as following? Thanks
The commands you will need are here: http://www.postgresql.org/docs/9.3/interactive/sql-commands.html In particular: CREATE TABLE http://www.postgresql.org/docs/9.3/interactive/sql-createtable.html INSERT http://www.postgresql.org/docs/9.3/interactive/sql-insert.html
Pierre rule: 1. just one column which type is integer in table 2. this columns only has 1 and 2 for 50 times as following 1 2 1 2 1 2 1 2 .....
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general