[SQL] Select between two connections

Hello everyone, I would like to perform a Select statement that accesses tables and finds matching fields in two separate databases. For example, I have two connections to two separate database objects on the same Postgres server. I would like to retrieve information from a table in one databa

Re: [SQL] Range of Serial values

Thank you Poul and Justin, I'll give it a try!!! ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Range of Serial values

Hello everyone, when creating a serial column, is there a way to specify which number it will start counting from? For example, if you wanted all Serial ID's to start at 1000 and count up from there, with no numbers below that. Thanks, Chris. ---(end of broadcast)-

Re: [SQL] Re: \i command

I don't know if you've resolved your problem, but if not, you could try deleting and recreating the indexes on the table... Najm Hashmi wrote: > Joel Burton wrote: > > > On Wed, 11 Apr 2001, Najm Hashmi wrote: > > > > > Hi All, > > > From pgsql, I try to insert data in table using the \i com

[SQL] Getting Results From Trigger

Hello everyone, I was hoping someone could help me with this... I'm running postgres 7.02 on redhat 6.2, apache 1.3.14 and mod_perl 1.24_01. I'm also using perl modules DBI 1.14 and DBD-Pg-0.95 to acces the Postgres database. Everytime my inventory file gets updated, I would like to have the q