[GENERAL] how to create multiple databases running in different dirs

Hi, I'm new to postgresql and sql in general. I desired to write a program in C that used an sql data base for IPC and because multiple copies of my program might run on the same machine I wanted a way to ensure that only one copy of each multithreaded program got one database but I'm uncertain how

Re: [GENERAL] how to create multiple databases running in different dirs

> how would an instance of your program know what to connect to, or which > previous instance its 'predecessor' was ? > normally, you have ONE database for a given set of applications, and all > the applications share the same database tables and such. That's the problem, is there some way to t

[GENERAL] Define OID

Hello, I can't seem to find the allowed values for OIDs. result = PQprepare(parrentcon, insertstmt, insert, 2, /*FIXME*/); Both arguments are to be of type char * in C and of type varchar(255) in sql. I looked in the docs but I can't seem to find where OIDs are enumerated, please point me in the

[GENERAL] newbie how to access the information scheme

Hello, I'd like to see all the tables in my data base, but can't figure out how to access th information scheme. Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] newbie how to access the information scheme

Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general