Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

PostgreSQL Data Types

memorize.ai (lvl 286)

(0)

24 cards

()

Section 1

Preview this deck

VARCHAR(n)

Front

1 / 24

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (24)

Section 1

(24 cards)

VARCHAR(n)

Front

variable-length character string

Back

float8 (real)

Front

double-precision (8-byte) floating-point number

Back

lseg

Front

line segment

Back

UUID

Front

Universal Unique Identifiers

Back

JSON

Front

JSON data

Back

float(n)

Front

floating-point number with precision of at least n

Back

boolean

Front

true, false, or null

Back

inet

Front

an IPv4 address

Back

TIME

Front

time of day

Back

line

Front

set of points

Back

TIMESTAMP

Front

both date and time

Back

TIMESTAMPTZ

Front

timezone-aware timestamp

Back

SMALLINT

Front

2-byte signed integer

Back

SERIAL

Front

same as INT, except PostgreSQL will automatically generate and populate values into the data column

Back

INTERVAL

Front

periods of time

Back

DATE

Front

date

Back

numeric(p,s)

Front

real number with p digits and s numbers after the decimal point

Back

CHAR(n)

Front

fixed-length character with space padded

Back

point

Front

geometric pair of numebrs

Back

INT

Front

4-byte integer

Back

polygon

Front

a closed geometric

Back

box

Front

rectangular box

Back

TEXT

Front

variable-length character string (unlimited length)

Back

macaddr

Front

a MAC address

Back