From: | Aleksey Dashevsky <postgres(at)luckynet(dot)co(dot)il> |
---|---|
To: | Brian <signal(at)shreve(dot)net> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] datatype questions |
Date: | 1998-06-24 09:13:21 |
Message-ID: | Pine.LNX.3.96.SK.980624120945.26065C-100000@kesha.luckynet.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 22 Jun 1998, Brian wrote:
> I am trying to convert a table into PostgresSQL from MySQL, and had a few
> questions:
>
> CREATE TABLE forum (
> id int(11) DEFAULT '0' NOT NULL auto_increment,
> name varchar(30),
> email varchar(100),
> topic varchar(50),
> body blob,
> host varchar(50),
> thread int(11) DEFAULT '0' NOT NULL,
> datestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
> KEY datestamp (datestamp),
> PRIMARY KEY (id),
> KEY thread (thread)
> );
>
> 1. Where in the documentation can you look to find what "modifiers" are
> supported by postgres after the declaration of the field. such as NOT
> NULL, PRIMARY KEY, KEY, DEFAULT, UNIQUE, etc. I call them modifiers but
> what are they really called?
Please, check PostgreSQL manual pages.
Also, there are HTMLized version of mans on the Web:
http://www.postgresql.org/docs/man/
What do you exactly need: create_table(l) , create_sequence(l) and
create_index(l) pages.
Aleksey.
From | Date | Subject | |
---|---|---|---|
Next Message | Antonio Garcia Mari | 1998-06-24 11:58:24 | Re: [GENERAL] datatype questions |
Previous Message | Mattias Kregert | 1998-06-24 07:49:37 | Re: [GENERAL] Q: How to convert int to date? |