Re: Change key primary for key foreign - Mailing list pgsql-general

From Guilherme Rodrigues
Subject Re: Change key primary for key foreign
Date
Msg-id 4c5f940e-e2c0-4f93-97e2-208849f4c8a4@googlegroups.com
Whole thread Raw
In response to Change key primary for key foreign  (Guilherme Rodrigues <lopesgrml@gmail.com>)
Responses Re: Change key primary for key foreign
Re: Change key primary for key foreign
List pgsql-general
I created one table so:

CREATE TABLE clima (
    city     char(80),
    cprc     int,
);

And have other table so:

CREATE TABLE city (
    name            char(80),
    other_thing     int,
);

But now I want the table clima receive name table city as foreign key. understand?
Sorry my bad english.


Em terça-feira, 18 de setembro de 2012 17h37min59s UTC-3, Guilherme Rodrigues  escreveu:
> Hello. I want to change one table already created. Where the comand? thank you.



pgsql-general by date:

Previous
From: Eden Cardim
Date:
Subject: Re: Column aliases in WHERE clauses
Next
From: Chris Travers
Date:
Subject: Re: Column aliases in WHERE clauses