RE: Backup Functions - Mailing list pgsql-sql
| From | Sridhar Parepalli |
|---|---|
| Subject | RE: Backup Functions |
| Date | |
| Msg-id | DM6PR05MB626583E98C8C1F35BD9253C0F3FF9@DM6PR05MB6265.namprd05.prod.outlook.com Whole thread Raw |
| In response to | Re: Backup Functions (Tom Lane <tgl@sss.pgh.pa.us>) |
| Responses |
Re: Backup Functions
Re: Backup Functions |
| List | pgsql-sql |
Hey Tom,
Here's what I got from the \df ...
tenant1=# \df
List of functions
Schema | Name | Result data type | Argument data
types | Type
--------+----------------------------------+------------------+---------------------------------------------------------------------------------------------------------+------
public | armor | text | bytea
| func
public | armor | text | bytea, text[], text[]
| func
public | crypt | text | text, text
| func
public | dearmor | bytea | text
| func
public | decrypt | bytea | bytea, bytea, text
| func
public | decrypt_iv | bytea | bytea, bytea, bytea, text
| func
public | digest | bytea | bytea, text
| func
public | digest | bytea | text, text
| func
public | dmc_update_row_modified_function | trigger |
| func
public | encrypt | bytea | bytea, bytea, text
| func
public | encrypt_iv | bytea | bytea, bytea, bytea, text
| func
public | gen_random_bytes | bytea | integer
| func
public | gen_random_uuid | uuid |
| func
public | gen_salt | text | text
| func
public | gen_salt | text | text, integer
| func
public | hmac | bytea | bytea, bytea, text
| func
public | hmac | bytea | text, text, text
| func
public | pgp_armor_headers | SETOF record | text, OUT key text, OUT value text
| func
public | pgp_key_id | text | bytea
| func
public | pgp_pub_decrypt | text | bytea, bytea
| func
public | pgp_pub_decrypt | text | bytea, bytea, text
| func
public | pgp_pub_decrypt | text | bytea, bytea, text, text
| func
public | pgp_pub_decrypt_bytea | bytea | bytea, bytea
| func
public | pgp_pub_decrypt_bytea | bytea | bytea, bytea, text
| func
public | pgp_pub_decrypt_bytea | bytea | bytea, bytea, text, text
| func
public | pgp_pub_encrypt | bytea | text, bytea
| func
public | pgp_pub_encrypt | bytea | text, bytea, text
| func
public | pgp_pub_encrypt_bytea | bytea | bytea, bytea
| func
public | pgp_pub_encrypt_bytea | bytea | bytea, bytea, text
| func
public | pgp_sym_decrypt | text | bytea, text
| func
public | pgp_sym_decrypt | text | bytea, text, text
| func
public | pgp_sym_decrypt_bytea | bytea | bytea, text
| func
public | pgp_sym_decrypt_bytea | bytea | bytea, text, text
| func
public | pgp_sym_encrypt | bytea | text, text
| func
public | pgp_sym_encrypt | bytea | text, text, text
| func
public | pgp_sym_encrypt_bytea | bytea | bytea, text
| func
public | pgp_sym_encrypt_bytea | bytea | bytea, text, text
| func
public | pgpool_pgctl | boolean | action text, stop_mode text
| func
public | pgpool_recovery | boolean | script_name text, remote_host text,
remote_data_directorytext | func
public | pgpool_recovery | boolean | script_name text, remote_host text,
remote_data_directorytext, remote_port text | func
public | pgpool_recovery | boolean | script_name text, remote_host text,
remote_data_directorytext, remote_port text, recovery_node integer | func
public | pgpool_remote_start | boolean | remote_host text, remote_data_directory text
| func
public | pgpool_switch_xlog | text | arcive_dir text
| func
(43 rows)
Sridhar Parepalli
-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Wednesday, August 18, 2021 12:17 PM
To: Sridhar Parepalli <Sridhar.Parepalli@sas.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: Backup Functions
EXTERNAL
Sridhar Parepalli <Sridhar.Parepalli@sas.com> writes:
> I was just wondering should a schema of a database contain functions and triggering functions does the pg_dump
includefunctions as it takes back up of the schema? I'm on postgres 11 version.
Functions belonging to extensions are not included in pg_dump output, maybe that explains your results? It's hard to
besure without a lot more specifics than you've provided.
regards, tom lane