Re: How to create a specific table - Mailing list pgsql-general

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@aklaver.com