Return default value

Snippets

return_default_value function

Works with PostgreSQL

Any version

Written in

plpgsql

Depends on

Nothing

Author: Emanuel

This function return the default value of a column:

CREATE FUNCTION ret_def(text,text,text) RETURNS text AS $$
SELECT 
  columns.column_default::text
FROM 
  information_schema.columns
  where table_name = $2
  and table_schema = $1
  and column_name = $3
$$ LANGUAGE sql IMUTABLE;

Just call it at this way:

SELECT ret_def('schema','table','column');