Re: How to create a specific table

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Pierre Hsieh <pierre(dot)hsieh(at)gmail(dot)com>, Brian Dunavant <brian(at)omniti(dot)com>, Rémi Cura <remi(dot)cura(at)gmail(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>, rod <rod(at)iol(dot)ie>, Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
Subject: Re: How to create a specific table
Date: 2015-01-22 15:00:49
Message-ID: 54C110A1.1030601@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrey Lizenko 2015-01-22 15:01:17 Re: temporary tables are logged somehow?
Previous Message David G Johnston 2015-01-22 14:59:53 Re: How to create a specific table