Part 1: How to use the PostgreSQL ARRAY Data type: search, insert, unnest, search by index.

preview_player
Показать описание
In this video, you will learn how to use the ARRAY data type. Store ARRAY data in your table.

Learn how to search, insert, unnest PostgreSQL ARRAY Data type the easy way.

I made this video for you. I hope you'll be able to implement the ARRAY data type in any table and use in your SQL statements, without the struggle I went through.

I will teach you how to create a column in a type that uses the ARRAY data type, how to insert data into a table, and 12 SELECT statements that extract data out of the data table.

At the end of this video, you will know how to implement the ARRAY data type in your database.

Unnesting arrays in PostgreSQL tutorial
PostgreSQL array unnesting for beginners

To View Part Two:

Uses
i) unnest - Expands an array into a set of rows.
ii) selecting a range of data items
iii) contains
iv) array_length - Returns the length of the requested array dimension.
v) insert statement
vi) create table using array data type

Software nugget. array data type, array datatype.
#softwareNuggets, #postgreSQL, #array, #arrayDataType, @SoftwareNuggets , #share_to_be_better
Рекомендации по теме
Комментарии
Автор

Hey Team, here is the source code for this video. Enjoy.

SoftwareNuggets
Автор

Just what I needed. So much info presented in a concise way. Great video!

petergartin
Автор

Thank you so much for this tutorial. Short, precise and easy to grasp!

arkadiptadas
Автор

A near perfect tutorial! Concise and explanatory. One question: what is the difference between @> and ANY. They seem the same to me.

benjamin-lieb
Автор

I found this great and incredibly helpful! You forgot to go over && which check if any of the elements are in the array

i.e SELECT country_code, colors FROM loc_country_m WHERE colors && '{"black", "red"}'

CarloNyte
Автор

Was kinda unexpected when you said Subzero. :D

johk
Автор

This is very useful. Thanks!
What is the difference between any and contains?

amol
Автор

Can you please make the video on Json for PostgeSQL

ajinkyagaikwad
Автор

how to import array form csv to postgreSQL?

adee