Instrucciones comunes para Postgresql

/* == VERSIÓN == */
SELECT version();

/* LISTAR DETALLES DE COLUMNAS DE LA BASE DE DATOS ACTUAL */
SELECT
	table_schema, 
	table_name, 
	column_name,
	data_type,
	is_nullable,
	column_default,
	character_maximum_length, 
	numeric_precision, 
	datetime_precision
FROM
	information_schema.columns
WHERE
	table_schema NOT IN ('information_schema','pg_catalog')
ORDER BY table_schema, table_name, ordinal_position