sudo apt-get install postgresql-contrib postgresql-plpython3-13 CREATE EXTENSION plpython3u;
Devamını Oku »ubuntu server 20.04 install postgresql and remote access
sudo apt-get update sudo apt-get upgrade sudo reboot sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update sudo apt-get -y install postgresql dikkat aşağıdaki işlem veritabanı sunucunuzu tamamen dışarıya açar bilinçli bir şekilde yaptığınızdan …
Devamını Oku »postgresql find dependent object
https://stackoverflow.com/questions/4462908/find-dependent-objects-for-a-table-or-view SELECT dependent_ns.nspname as dependent_schema , dependent_view.relname as dependent_view , source_ns.nspname as source_schema , source_table.relname as source_table , pg_attribute.attname as column_name FROM pg_depend JOIN pg_rewrite ON pg_depend.objid = pg_rewrite.oid JOIN pg_class as dependent_view ON pg_rewrite.ev_class = dependent_view.oid JOIN pg_class as source_table ON pg_depend.refobjid = source_table.oid JOIN pg_attribute ON pg_depend.refobjid …
Devamını Oku »Postgresql Truncate restart identity
truncate table tbl_a,tabl_b restart identity;
Devamını Oku »postgresql mail domain citext
CREATE EXTENSION citext; CREATE domain dmn_email AS citext check( VALUE ~'^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+[.][A-Za-z]+$'); SELECT 'zamazingo@zamazingo.com'::dmn_email;
Devamını Oku »postgresql smallint default year field
year SMALLINT NOT NULL DEFAULT EXTRACT (YEAR FROM CURRENT_DATE)
Devamını Oku »postgresql gtip noktalı çevir
create or replace function fn_getGtipNoktali(p_gtip varchar) returns varchar language plpgsql as $$ declare temp_gtip varchar; ret_gtip varchar; begin SELECT replace(p_gtip, '.', '') into temp_gtip; select SUBSTRING ( temp_gtip ,0 , 5 )||'.'||SUBSTRING ( temp_gtip ,5 , 2 )||'.'||SUBSTRING ( temp_gtip ,7 , 2 )||'.'||SUBSTRING ( temp_gtip ,9 , 2 )||'.'||SUBSTRING …
Devamını Oku »postgresql example function
create or replace function fn_getIsemriDurum(p_durum_id int) returns varchar language plpgsql as $$ declare ret_aciklama varchar; begin select aciklama into ret_aciklama from durumlar where id = p_durum_id; if not found then raise 'Durum id % not found', p_durum_id; end if; return ret_aciklama; end;$$
Devamını Oku »postgresql ymd() function
create or replace function ymd( p_year int, p_month int, p_day int) returns date language plpgsql as $$ declare ret_ymd date; begin SELECT TO_DATE(p_year::varchar||LPAD(p_month::varchar, 2, '0')||p_day::varchar,'YYYYMMDD') into ret_ymd; return ret_ymd; end;$$
Devamını Oku »postresql dmy() function
create or replace function dmy( p_day int, p_month int, p_year int) returns date language plpgsql as $$ declare ret_dmy date; begin SELECT TO_DATE(p_year::varchar||LPAD(p_month::varchar, 2, '0')||p_day::varchar,'YYYYMMDD') into ret_dmy; return ret_dmy; end;$$
Devamını Oku »