Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?

agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed

From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Karen Goh <karenworld@yahoo.com>
Cc: Avin Kavish <avinkavish@gmail.com>
Cc: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
Date: Sun, 21 Jul 2019 11:30:52 -0600
Message-ID: <BABAFCAB-0E7B-4AF9-A89C-80EC8D35201A@elevated-dev.com> (raw)
In-Reply-To: <1465046932.2664428.1563726642792@mail.yahoo.com>
References: <820008379.2579287.1563670685484@mail.yahoo.com>
	<5CE41E80-274A-44DA-9553-E2DCA260F751@jakobs.com>
	<385857992.2643116.1563717238725@mail.yahoo.com>
	<923fb3b1-90e9-e0b5-bc5b-d896128c3f28@gmail.com>
	<1745586001.2633224.1563719075867@mail.yahoo.com>
	<CAKFQuwYwO4EdGQ_H6avBUQaeUTOyoLFw17OicCXsFzVVri4aUw@mail.gmail.com>
	<905425626.2686338.1563721213121@mail.yahoo.com>
	<CAKFQuwahWO9HrmcNjkfkaj0cAbFJB6mTVEOUGQZiy9EojTJQOw@mail.gmail.com>
	<2030754658.2646264.1563721831668@mail.yahoo.com>
	<75125c45-0fed-e5f1-50f0-9646db20dde6@gmail.com>
	<927283546.2681887.1563722628862@mail.yahoo.com>
	<CAFpscOTUNm2JZ1Vbv2h+BCnW5k7+ZJXWSBv_aP69Z7gRZo2Qhw@mail.gmail.com>
	<1465046932.2664428.1563726642792@mail.yahoo.com>

This forum is recommended for questions regarding administration of PostgreSQL, which your questions are not related to. pgsql-gernal or pgsql-sql would be better fits.

But I'd strongly suggest that you pause and learn SQL basics in a structured way. You've said several times that you've been writing queries for a long time, but your questions here demontrate a serious lack of understanding of the basics. My personal recommendation:

https://www.postgresql.org/docs/11/tutorial-sql.html

Or, for a quicker start: 

https://www.postgresql.org/docs/11/tutorial-sql.html
https://www.postgresql.org/docs/11/sql.html

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/

view thread (26+ messages)  latest in thread

Message-ID: <BABAFCAB-0E7B-4AF9-A89C-80EC8D35201A@elevated-dev.com>
Permalink:  ../BABAFCAB-0E7B-4AF9-A89C-80EC8D35201A@elevated-dev.com/
Also on:    postgresql.org/message-id/BABAFCAB-0E7B-4AF9-A89C-80EC8D35201A@elevated-dev.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: scott_ribe@elevated-dev.com, karenworld@yahoo.com, avinkavish@gmail.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  In-Reply-To: <BABAFCAB-0E7B-4AF9-A89C-80EC8D35201A@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox