Re: [GENERAL] datatype questions

Ok, you're porting phorum to postgres. I've done the work before.

http://www.at4.net/phorum

Check the download page to get the sources.

And this is the sql for the table you want to create:


CREATE SEQUENCE forum_id_s INCREMENT 1 START 1;
CREATE TABLE forum (
  id int4 DEFAULT nextval('forum_id_s') NOT NULL PRIMARY KEY,
  name varchar(30),
  email varchar(100),
  topic varchar(50),
  body text,
  host varchar(50),
  thread int4 DEFAULT 0 NOT NULL,
  datestamp datetime DEFAULT 'now()' NOT NULL
);

> 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.
>
>
Antonio Garcia Mari
Mallorca (Spain)