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
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 |