[SQL] Primary key reference count

Hi, I'm trying to find which of the tables in pg_catalog contains the amount of references to a primary key, but I can't seem to find it. Google queries are also less than successful. Is it even stored in the catalog? ---(end of broadcast)--- TIP

Re: [SQL] Primary key reference count

am 19.04.2006, um 14:01:03 +0200 mailte Wiebe Cazemier folgendes: > Hi, > > I'm trying to find which of the tables in pg_catalog contains the amount of > references to a primary key, but I can't seem to find it. Google queries are > also less than successful. Is it even stored in the catalog? Y

Re: [SQL] Primary key reference count

On Wednesday 19 April 2006 15:09, A. Kretschmer wrote: > Yes, > http://www.postgresql.org/docs/8.1/interactive/catalog-pg-constraint.html Either I'm blind, or this is not what I'm looking for. I need to know the amount of references _to_ a primary key. If you have a customer with two orders and o

Re: [SQL] Primary key reference count

On Wednesday 19 April 2006 15:33, Wiebe Cazemier wrote: > Either I'm blind, or this is not what I'm looking for. I need to know the > amount of references _to_ a primary key. If you have a customer with two > orders and one invoice, the reference count for the primary key of the > custormer would

Re: [SQL] Primary key reference count

On Wednesday 19 April 2006 17:00, Wiebe Cazemier wrote: > Never mind. I found another solution. Whoops. Posted to quickly there. I do still need to know the amount of references to the primary key. ---(end of broadcast)--- TIP 1: if posting/readin

Re: [SQL] Primary key reference count

On Apr 19 02:01, Wiebe Cazemier wrote: > I'm trying to find which of the tables in pg_catalog contains the amount of > references to a primary key, but I can't seem to find it. Here's simple query, to list which table's which columns references to a specific table. (Hope this is what you asked for

[SQL] Field length ??

I've this table :create table test(]satu char(10),dua char(5));How could I get the Field length not the Data length ?Thanks,Rina Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice.

[SQL] Programatically Backup Database Using Visual Basic

Hi is there a way wherein I can interface the pg_dump of PostgreSQL Server in Visual basic. I mean for example I want to backup Databases "DB1", "BD12", "DB3" using pg_dump Thank You, Ian I choose Polesoft Lockspam to fight spam, and you? http://www.polesoft.com/refer.html ---

Re: [SQL] Programatically Backup Database Using Visual Basic

Paul, > Hi is there a way wherein I can interface the pg_dump of PostgreSQL Server > in Visual basic. > > I mean for example I want to backup Databases "DB1", "BD12", "DB3" using > pg_dump You'd have to run them as shell commands in VB. Not sure if VB has a mechanism for that. -- Josh Berkus

Re: [SQL] Field length ??

Hi ,With this table :create table test(satu char(10),dua char(5));To get the field length, I use this query:select atttypmod from pg_attribute where attname='satu' and attrelid=(select oid from pg_class where relname='test');---> result 1 : 14select atttypmod from pg_attribute where attname='dua' a