https://www.sqlines.com/ 2026-04-14T06:32:54+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2011-12-20T13:22:30+00:00 https://www.sqlines.com/postgresql/how-to/create_user_defined_type?rev=1324387350&do=diff You can create a user-defined type using CREATE DOMAIN and CREATE TYPE statements. Quick Example: -- Define a type using CREATE DOMAIN CREATE DOMAIN addr VARCHAR(90) NOT NULL DEFAULT 'N/A'; -- Define a type using CREATE TYPE CREATE TYPE address AS (city VARCHAR(90), street VARCHAR(90)); -- Use them in a table CREATE TABLE location (ship_address addr, full_address address); text/html 2023-02-19T14:17:48+00:00 https://www.sqlines.com/postgresql/how-to/dateadd?rev=1676816268&do=diff Although PostgreSQL does not provide DATEADD function similar to SQL Server, Sybase or MySQL, you can use datetime arithmetic with interval literals to get the same results. SQL Server: -- Add 1 day to the current date November 21, 2012 SELECT DATEADD(day, 1, GETDATE()); # 2012-11-22 17:22:01.423 text/html 2012-01-04T17:31:39+00:00 https://www.sqlines.com/postgresql/how-to/define_version?rev=1325698299&do=diff Connect to a PostgreSQL database, and execute version() function to find out the PostgreSQL version: -- Define the PostgreSQL version SELECT version(); The query returns (a sample output that depends on the system): version PostgreSQL 9.0.4, compiled by Visual C++ build 1500, 32-bit Resources * PostgreSQL Articles and Reference text/html 2012-01-03T09:35:52+00:00 https://www.sqlines.com/postgresql/how-to/pg_dump_database_file?rev=1325583352&do=diff pg_dump utility located in bin directory of PostgreSQL installation can be used to export database definitions and data to a SQL script. Quick Example pg_dump -U username dbname > dump.sql Extract Schema Only -s option Extract Data Only -a option Generate DROP statements -c option Export OIDs -o option How to Restore Use psql utility pg_dump Examples * Extact both schema and data from postgres database: text/html 2020-09-08T11:43:58+00:00 https://www.sqlines.com/postgresql/how-to/return_result_set_from_stored_procedure?rev=1599565438&do=diff Both stored procedures and user-defined functions are created with CREATE FUNCTION statement in PostgreSQL. * PostgreSQL Stored Procedures and Functions - Getting Started To return one or more result sets (cursors in terms of PostgreSQL), you have to use refcursor return type.