From: | moebius(at)ip-solutions(dot)net |
---|---|
To: | PostgresGeneral <pgsql-general(at)hub(dot)org> |
Subject: | New To List |
Date: | 2000-01-14 23:04:56 |
Message-ID: | 200001142304.PAA01362@spider.ip-solutions.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello All,
I'm not really sure how joining the list works but I
wanted to say hello. I am new to databases and also to
Postgres. Started reading the book up on the site. Very
helpful.
I do have a question though. I am trying to take a DB
written for MySql and convert the format of statements
over to Postgres for creation. I can't seem to find a
value 'blob' in PG. Is there something similar?? Also if
anyone can help me with this (see below). I can't figure
out how to make a primary, unique key. Here's the sql
file:
CREATE TABLE session (
sid varchar(255) NOT NULL,
val blob NOT NULL,
changed varchar(14) NOT NULL,
PRIMARY KEY (sid),
UNIQUE sid_2 (sid)
);
Again any help or pointers in the right direction is
greatly appreciated.
Kind regards,
Harry Hoffman
Product Systems Specialist
Restaurants Unlimited Inc.
(206) 634-3082 x. 270
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Heflin | 2000-01-14 23:08:27 | problem with date range |
Previous Message | Alfred Perlstein | 2000-01-14 22:52:28 | Re: [GENERAL] cgi with postgres |