Create a Postgres Table

Share this video with your friends

Send Tweet

Learn how to create a table using the most widely-used data types (serial, varchar, integer, float, boolean, and date), and the most necessary constraints (NOT NULL and primary key).

Brett Cassette
Brett Cassette(instructor)
~ 8 years ago

For anyone wondering more about setting up dev environment:

Check out the course Github

Kartikey Tanna
Kartikey Tanna
~ 8 years ago

You can use pgAdmin if you are on Windows

Brett Cassette
Brett Cassette(instructor)
~ 8 years ago

Thanks for helping people out Kartikey :)

Brendan Whiting
Brendan Whiting
~ 8 years ago

Can someone suggest a tutorial for getting set up with a database and hooking it up with the Postgres client? I downloaded the software but I don't know what to do next. In other words I'm looking for what I need to do to get ready for the first video in the series.

Brett Cassette
Brett Cassette(instructor)
~ 8 years ago

You can read the README on Github

Brendan Whiting
Brendan Whiting
~ 8 years ago

Awesome thx

Taeshik Hwang
Taeshik Hwang
~ 7 years ago

What is the program name that you use for postgresql in this lecture? I don't know what it is, so i can't start your lecture.

Taeshik Hwang
Taeshik Hwang
~ 7 years ago

What is the program name that you use for postgresql in this lecture? I don't know what it is, so i can't start your lecture.

Sorry I checked the reply above.

Lucas
Lucas
~ 7 years ago

Seems that someone felt offended by my previous comment and was deleted. So I'm re asking it: Is there any particular reason why all the videos are so fast paced? If so, what's the purpose on that? Feels that the author has taken for granted a lot of knowledge that audience is supposed to have (if that's the case there's absolutely no point in taking this course as you probably know most of it). On the other side if you're just new to a relational engine you will be absolutely confused (too many concepts terribly exposed and explained) as it does not have a clear goal in any section, it feels like a bad SQL medley. I'm not new to SQL and took this course just to remind a few things but completely failed that purpose.

Serge Bedzhik
Serge Bedzhik
~ 7 years ago

A little typo in the transcript. I think it should be "release_date" not "releas_date". Thanks.

Loïc
Loïc
~ 6 years ago

You can use pgAdmin if you are on Windows Or linux (ubuntu etc)

Nenad
Nenad
~ 6 years ago

Also dbeaver community edition is looking very good. https://dbeaver.io/