COMANDOS POSTGRE Flashcards by David Ap Fer

Q

\l

A

LISTAR BASES DE DATOS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\dt

A

LISTAR TABLAS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\d table_name

A

DESCRIBIR TABLAS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\dn

A

LISTAR ESQUEMAS SCHEMA

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\df

A

LISTAR FUNCIONES

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\dv

A

LISTAR VISTAS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\du

A

LISTAR USUARIOS Y SUS ROLES

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\g

A

VERSION

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\s

A

HISTORY

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\i filename

A

EJECUTAR COMANDDOS POSTGRE DE UN FICHERO

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\?

A

OBTENER AYUDA DE COMANDOS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\db

A

LISTAR TABLESPACES

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\q

A

SALIR DEL EDITOR

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

MOSTRAR INDICES

A

QUERY EN TABLA pg_indexes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

\dy

A

LISTAR TRIGGERS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly