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.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general