Etiket Arşivi: postgresql

TBL_TEST.unl dosyamızın sonunda ki pipe “|” yok etmek için python da küçük bir script ile temizleme yapıyoruz. fpath = 'deneme.unl' def read_big_file_pipe(): with open(fpath) as infile: with open("new_deneme.unl", "a", encoding='utf-8') as file_object: for line in infile: new_line = line[:-2]+'\n' file_object.write(new_line)   postgresql sunucusunda ki tmp dizinine kopyalıyoruz. tablomuzu ilgili veritabanında …

create domain dmn_tescilno varchar(16) check ( value ~ '^[0-9]{8}((IM)|(EX)|(AN)|(TR)|(DG)|(T0)|(C0)|(B0)|(G0)|(M0)|(R0)|(RL))[0-9]{6}$'); select '22222222AN111111'::dmn_tescilno;  

Bazen yazdığımız bir sorguyu json olarak çıktı vermek isteriz create table testfatura( id serial primary key not null, fatura_no varchar(10) not null, aciklama varchar(100) not null ); create table testfatura_detay( id serial primary key not null, testfatura_id int not null references testfatura(id), stokkodu varchar(50), stokadi varchar(50) ); insert into testfatura …

CREATE EXTENSION plpython3u; CREATE OR REPLACE FUNCTION caesarCipher(realtext text, step int) RETURNS TEXT AS $$ outText = [] cryptText = [] uppercase = ['A', 'B', 'C', 'Ç', 'D', 'E', 'F', 'G', 'Ğ', 'H', 'I', 'İ', 'J', 'K', 'L', 'M', 'N', 'O', 'Ö', 'P', 'Q', 'R', 'S', 'Ş', 'T', 'U', 'Ü', …

CREATE OR REPLACE FUNCTION isvalid_tckn(tckn text) RETURNS bool AS $$ value = str(tckn) if not len(value) == 11: return False # Sadece rakamlardan olusur. if not value.isdigit(): return False # Ilk hanesi 0 olamaz. if int(value[0]) == 0: return False digits = [int(d) for d in str(value)] # 1. 2. …

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 …

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 …

truncate table tbl_a,tabl_b restart identity;  

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;  

year SMALLINT NOT NULL DEFAULT EXTRACT (YEAR FROM CURRENT_DATE)