Re: Moving from MySQL to PostgreSQL with Ruby on Rails. - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Moving from MySQL to PostgreSQL with Ruby on Rails.
Date
Msg-id 20051117211037.GA17888@wolff.to
Whole thread Raw
In response to Re: Moving from MySQL to PostgreSQL with Ruby on Rails.  (Robby Russell <robby.lists@planetargon.com>)
Responses Re: Moving from MySQL to PostgreSQL with Ruby on Rails.  (Robby Russell <robby@planetargon.com>)
List pgsql-general
On Thu, Nov 17, 2005 at 09:23:51 -0800,
  Robby Russell <robby.lists@planetargon.com> wrote:
>
> CREATE TABLE product (
>   id SERIAL PRIMARY KEY,
>   name VARCHAR(255) NOT NULL DEFAULT '',
> );

And depending on why you chose VARCHAR(255), you may really want to use TEXT
instead.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Partial foreign keys, check constraints and
Next
From: Reid Thompson
Date:
Subject: [Fwd: Sun backs open-source database PostgreSQL | Topic: "everything" | ZDNet News Alerts]