Re: SUMMARY mysql -> psql

From: Richard Huxton <dev(at)archonet(dot)com>
To: expect <expect(at)ihubbell(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: SUMMARY mysql -> psql
Date: 2003-09-10 08:23:46
Message-ID: 200309100923.46874.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 10 September 2003 03:33, expect wrote:
> CREATE TABLE outbound (
> source character(100) DEFAULT '',
> destination character(100) DEFAULT '',
> sport integer DEFAULT 0 NOT NULL,
> dport integer DEFAULT 0 NOT NULL,
> "time" timestamp without time zone DEFAULT now() NOT NULL,
> id bigint DEFAULT nextval('serial'::text) NOT NULL
> );

I'm guessing it's too late in the day to change it now, but I'd be sorely
tempted to rename that "time" column to something else (otime?)
--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-09-10 08:29:07 Re: Adding header nam to any table
Previous Message Richard Huxton 2003-09-10 08:20:51 Re: Temp tables and copy