Re: Foreing Key in Postgres ????

From: phil(at)Stimpy(dot)netroedge(dot)com
To: Pablo Salazar <ssalazar(at)goliat(dot)espol(dot)edu(dot)ec>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: Foreing Key in Postgres ????
Date: 2000-07-24 22:13:54
Message-ID: 20000724151354.P9654@Stimpy.netroedge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


I think this might be a little out of place (wrong list?), but here's
a quick answer:

select tableone.name,tabletwo.title where
tableone.index=tabletwo.index order by tableone.name asc;

That's a simple relational selection for two tables which might look
like:

tableone:
name text
index int4

tabletwo:
title text
index int4

Good luck!

Phil

On Mon, Jul 24, 2000 at 04:49:31PM -0500, Pablo Salazar wrote:
> Hellos Folks!!
>
> Someane , know be do relations between tables (FK)
>
> please Help me
> thanks
>
> Pablo

Content-Description: Card for Pablo Salazar

--
Philip Edelbrock -- IS Manager -- Edge Design, Corvallis, OR
phil(at)netroedge(dot)com -- http://www.netroedge.com/~phil
PGP F16: 01 D2 FD 01 B5 46 F4 F0 3A 8B 9D 7E 14 7F FB 7A

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message David C Mudie 2000-07-25 00:20:35 JDBC DateTime broken in postgresql-7.02?
Previous Message Pablo Salazar 2000-07-24 21:49:31 Foreing Key in Postgres ????