PostgreSQL

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/10

flashcard set

Earn XP

Description and Tags

Questions taken from Quizzes

11 Terms

1
New cards

PostgreSQL is classified as a: 

Relational database

2
New cards

Which GUI tool is commonly used for PostgreSQL?

pgAdmin

3
New cards

Default port for PostgreSQL?

5432

4
New cards

Which SQL command lists databases in PostgreSQL’s psql tool?

\l

5
New cards

In PostgreSQL, a server can contain:

Multiple databases

6
New cards

Which command exits the psql shell?

\exit

7
New cards

Which is NOT a valid PostgreSQL data type?

DOCUMENT

8
New cards

PostgreSQL supports:

Both SQL and JSON data types

9
New cards

The tool ‘psql’ is used to:

Connect and run SQL commands

10
New cards

A PostgreSQL cluster refers to:

A single server managing multiple databases

11
New cards

What is PostgreSQL default schema?

public