CYBERTEC PostgreSQL Logo

Tag: foreign key

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: foreign key. You can go back to all blog posts or take a look into our other categories & tags.

PostgreSQL: Foreign keys and insertion order in SQL

by Hans-Jürgen Schönig | 10.2020
Foreign keys will introduce some issues which have to be considered when writing applications. If a foreign key is in place the inseration order starts to matter.

1-to-1 relationship in PostgreSQL for real

by Pavlo Golub | 05.2019
How to implement 1-to-1 relationship in PostgreSQL? Tricks with UNIQUE constraints? Check how to achive that using DEFERRABLE foreign keys.

Foreign Key Indexing and Performance in PostgreSQL

by Laurenz Albe | 10.2018
Foreign key constraints are an important tool to keep your database consistent while also documenting relationships between tables. A fact […]

PostgreSQL: Indexes and foreign keys

by Hans-Jürgen Schönig | 07.2017
Missing indexes and foreign keys may cause database performance problems. Learn how to speed up things dramatically - not only in PostgreSQL!
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram