Instantly share code, notes, and snippets.

maximal/table-structure.pg.sql

Last activeApril 12, 2022 11:51

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/maximal/236e5806de3149a6a0adebdeba002935.js"></script>
Save maximal/236e5806de3149a6a0adebdeba002935 to your computer and use it in GitHub Desktop.

Clone this repository at <script src="https://gist.github.com/maximal/236e5806de3149a6a0adebdeba002935.js"></script>

Save maximal/236e5806de3149a6a0adebdeba002935 to your computer and use it in GitHub Desktop.

Структура таблиц PostgreSQL

	-- Структура таблиц PostgreSQL
	-- Порядок колонок не сохранён, таблицы и колонки отсортированы в алфавитном порядке
	-- Удобно для сравнения структур нескольких баз, можно делать дифф
	--
	-- @since 2022-04-12
	-- @author MaximAL

	SELECT table_name, column_name, column_default, is_nullable, data_type,
	character_maximum_length, character_octet_length, numeric_precision, numeric_precision_radix, numeric_scale,
	datetime_precision, interval_type, interval_precision,
	character_set_catalog, character_set_schema, character_set_name,
	collation_catalog, collation_schema, collation_name
	FROMINFORMATION_SCHEMA.columns
	WHERE table_schema='public'
	ORDER BY table_name, column_name

Movatterモバイル変換