Unique Constraint with foreign Key

From: mohan(at)physics(dot)gmu(dot)edu
To: <pgsql-sql(at)postgresql(dot)org>
Cc: <torque-user(at)db(dot)apache(dot)org>
Subject: Unique Constraint with foreign Key
Date: 2004-02-10 17:03:36
Message-ID: 64366.138.88.163.115.1076432616.squirrel@physics.gmu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all i am using postgres and torque
I have a column x in Table A of type varchar and NOT NULL. I want to
impose a unique key constraint on that table and column y is the primary
key.
I have another Table B with column x. can i make this column x as a
foreign key on column x in table A.
or Can i have varchar types of size 50 as primary keys in Postgres.

please let me know

--Mohan

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Sterling 2004-02-10 18:14:04 max timestamp
Previous Message beyaNet Consultancy 2004-02-10 12:04:42 Trace for postgreSQL