https://sqlines.com/ 2026-04-04T08:04:05+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2012-03-21T19:36:36+00:00 https://sqlines.com/postgresql/statements/create_domain?rev=1332358596&do=diff CREATE DOMAIN statement creates a user-defined data type with a range, optional DEFAULT, NOT NULL and CHECK constraint. A domain is an alias for a built-in data type. Quick Example: -- Define a type CREATE DOMAIN addr VARCHAR(90); -- Use it in a table CREATE TABLE location (address addr); text/html 2023-12-04T18:31:19+00:00 https://sqlines.com/postgresql/statements/create_temporary_table?rev=1701714679&do=diff CREATE TEMPORARY TABLE statement creates a temporary table that is automatically dropped at the end of a session, or the current transaction (ON COMMIT DROP option). Quick Example: -- Create a temporary table CREATE TEMPORARY TABLE temp_location ( city VARCHAR(80), street VARCHAR(80) ) ON COMMIT DELETE ROWS;