Re: [GENERAL] A question on pg_stat_subscription view

Hello, You can find more information about that view and its columns. https://www.postgresql.org/docs/devel/static/monitoring-stats.html#pg-stat-subscription Regards, Gunce On 22 Oct 2017 Sun at 11:11 Önder Kalacı wrote: > Hi, > > I'm trying to understand the view

Re: [GENERAL] PostgreSQL Source Control Integration

Hello Adrian, Thank you for your suggest, I'll examine and decide to use it. Regards, Gunce On Wed, Jun 21, 2017 at 3:45 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 06/21/2017 05:08 AM, Günce Kaya wrote: > >> Hi, >> >> I work on PostgreSQL 9.6 and

[GENERAL] PostgreSQL Source Control Integration

Hi, I work on PostgreSQL 9.6 and I'm looking for a source code control tool. Is there anyone who give a suggest about that? Best Regards, -- Gunce Kaya Linkedin - Twitter - Blog

Re: [GENERAL] [ADMIN] calculating table and index size

7 4:58 PM, "Alban Hertroys" <haram...@gmail.com> a écrit : > > On 7 April 2017 at 09:11, Günce Kaya <guncekay...@gmail.com> wrote: > > Hi again, > > > > Sorry for delay. > > > > Guillaume, I read your answer for first question but It's not clear

Re: [GENERAL] [ADMIN] calculating table and index size

you will figure it out. > > Steven > > 2017-04-05 16:56 GMT+08:00 Guillaume Lelarge <guilla...@lelarge.info>: > >> Hi, >> >> 2017-04-05 9:44 GMT+02:00 Günce Kaya <guncekay...@gmail.com>: >> >>> Hi all, >>> >>> I have

[GENERAL] calculating table and index size

Hi all, I have some questions about calculating table and index size. I have a dummy table which has an integer column and its index. The table has 140 rows and all of rows are same thats value is 2000. Table size is 50MB and index size is 31MB. Why there is too much size difference

Re: [GENERAL] import CSV file to a table

Hi, When I open a new thread, I didn't know exactly what is true words to research. I read all of your posts and I think CSV parsing is the point to me. I've created my script and I share it to record. #cat cargo2.sh #!/bin/bash while IFS=, read uor_desc crime_type zip_code ucr_hierarchy

[GENERAL] import CSV file to a table

Hi all, I want to import content of CSV file to a table via bash script without creating temporary table and I also want to skip some columns in CSV file (for instance, CSV file has 12 column and main table has only 2 column, If possible I would use only 2 column in CSV file) Is there any way to

Re: [GENERAL] Fwd: parameter type is unknown error

tsc...@swisspug.org >: > Hallo Adrian > > > -Original Message- > > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-owner@ > postgresql.org] On Behalf Of Adrian Klaver > > Sent: Montag, 6. März 2017 15:13 > > To: Günce Kaya <gun

Re: [GENERAL] Fwd: parameter type is unknown error

7-03-06 15:22 GMT+03:00 Charles Clavadetscher <clavadetsc...@swisspug.org >: > Hello Günce > > > > *From:* pgsql-general-ow...@postgresql.org [mailto:pgsql-general-owner@ > postgresql.org] *On Behalf Of *Günce Kaya > *Sent:* Montag, 6. März 2017 13:01 > *To:* Charles C

Re: [GENERAL] Fwd: parameter type is unknown error

and argument types. You might need to add explicit type casts. It seems nothing changed. Yours sincerely, Gunce 2017-03-06 15:00 GMT+03:00 Günce Kaya <guncekay...@gmail.com>: > Hi Charles, > > Thank you for your response. I used pg_typeof() function to show > parameter

Re: [GENERAL] Fwd: parameter type is unknown error

you have any advice for that? Regards, Gunce 2017-03-06 14:51 GMT+03:00 Charles Clavadetscher <clavadetsc...@swisspug.org >: > Hello > > > > *From:* pgsql-general-ow...@postgresql.org [mailto:pgsql-general-owner@ > postgresql.org] *On Behalf Of *Günce Kaya > *Sent:*

[GENERAL] Fwd: parameter type is unknown error

Hi all, I created a dummy table and related function that include insert script. When I execute the function I'm getting error like bellow; ERROR: function cargo.insertinvoice(integer, integer, integer, *unknown, unknown, unknown*, integer, timestamp with time zone, integer, integer, money,

Re: [GENERAL] Er Data Modeller for PostgreSQL

> On Thu, Dec 22, 2016 at 11:50 PM, Günce Kaya <guncekay...@gmail.com> > wrote: > >> Hi All, >> >> I'm looking for an ER Data Modeller tool for postgresql. I use Navicat >> Premium for postgresql and the tool has a modeller but I would like to >&g

Re: [GENERAL] Er Data Modeller for PostgreSQL

Hi, Thank you for your response. This document is pretty good to use SchemasPy and thank you for your sharing but I could not integrate with our postgres yet. I'm looking for a database tool like Toad, DBVisualizer so on. It'll be more useful to me now. Regards, Gunce Kaya 2016-12-23 12:44

[GENERAL] Er Data Modeller for PostgreSQL

Hi All, I'm looking for an ER Data Modeller tool for postgresql. I use Navicat Premium for postgresql and the tool has a modeller but I would like to display a database modeller that belonging to a tables of an schema under a database. If I use Navicat for modeller, I have to drag and drop whole