Re: [SQL] Information passing, Perl, Unix and Postgresql Database

On Wed, May 09, 2001 at 02:38:14PM -0400, Issurdatt, Portia CECOM RDEC STCD SRC wrote: > I need to extract information from a database table, do another query on > that information, then pass only the new information to a new table using > postgresql database and Unix. You might be able t

[SQL] Information passing, Perl, Unix and Postgresql Database

I need to extract information from a database table, do another query on that information, then pass only the new information to a new table using postgresql database and Unix. Any suggestions will be helpful! Thanks, Portia ---(end of broadcast)-

Re: [SQL] no more pg_dump cause of multiple declared database??

[EMAIL PROTECTED] (Bruno Boettcher) writes: > fibu=# \l > List of databases > Database | Owner | Encoding > ---+--+--- > admin | www | SQL_ASCII > fibu | bboett | SQL_ASCII > fibu | hordemgr | SQL_ASCII > horde

Re: [SQL] General ISA and Foreign Key

I thank you very much for your help. Regards, Lionel ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing lis

Re: [SQL] INT8 sequences

Radius Administrator wrote: > > Is it true that PostgreSQL sequences are always INT4? If so, how Yep > would the following be modified to work as obviously intended? > > CREATE SEQUENCE tbl_id INCREMENT 1 START 1; > CREATE TABLE tbl > ( > id INT8 DEFAULT NEXTVAL('tbl_id')

[SQL] no more pg_dump cause of multiple declared database??

Hello a problem i am encountering quite frequently lately. for some reason my databases are registered under several users and making a pg_dump gives me the following error: getDatabase(): SELECT failed. Explanation from backend: 'ERROR: More than one tuple returned by a subselect used as