Sql

Search

postgres list all stored procedures query

select n.nspname as schema,
       p.proname as procedure
from pg_proc p
join pg_namespace n on p.pronamespace = n.oid
where n.nspname not in ('pg_catalog', 'information_schema')
	and p.prokind = 'p'

Comment

PREVIOUS	NEXT

Code Example
Sql :: oracle search in date columns
Sql :: mysql limit offset
Sql :: sql order by case
Sql :: show data in table postgres
Sql :: grant all privileges mysql
Sql :: mysql docker compose
Sql :: postgresql update between 2 tables
Sql :: vacuum table postgres
Sql :: mssql find deadlocks
Sql :: coalesce postgresql
Sql :: shrink database file in sql server
Sql :: what is my mysql version
Sql :: SQL loop with cursor
Sql :: delete top N rows in sql
Sql :: sql where max date
Sql :: what is integrity constraints
Sql :: change column name in sql
Sql :: sql update null values
Sql :: how to get nearest location in mysql with latitude and longitude
Sql :: mysql else if
Sql :: oracle show column of table
Sql :: sql decimal vs float
Sql :: mariadb alter table add column if not exists example
Sql :: mysql cashing error
Sql :: select sequence oracle
Sql :: sql declare table variable
Sql :: sql get the name of user pc
Sql :: how to get the date from datetime in mysql
Sql :: java sql timestamp now
Sql :: sql select most frequent value in column

Search

SQL

postgres list all stored procedures query

ADD CONTENT