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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Karen Goh <karenworld@xxxxxxxxx>
Subject: Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
From: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>
Date: Sun, 21 Jul 2019 11:30:52 -0600
Cc: Avin Kavish <avinkavish@xxxxxxxxx>, Ron <ronljohnsonjr@xxxxxxxxx>, pgsql-admin@xxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxx
https://www.linkedin.com/in/scottribe/

References:
- How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Karen Goh
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Holger Jakobs
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Karen Goh
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Ron
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Karen Goh
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: David G. Johnston
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Karen Goh
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: David G. Johnston
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Karen Goh
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Ron
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Karen Goh
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Avin Kavish
- Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  - From: Karen Goh

Prev by Date: Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
Next by Date: pguint Installation error in PostgreSQL server version 11.2
Previous by thread: Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
Next by thread: pguint Installation error in PostgreSQL server version 11.2
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]