[GENERAL] Running PostgreSQL on Windows 9x/2000/2003...

How to I run PostgreSQL on an Intel machine with Windows? Thanks, Thomas _ MSN Movies - Trailers, showtimes, DVD's, and the latest news from Hollywood! http://movies.msn.click-url.com/go/onm00200509ave/direct/01/

Re: [GENERAL] How to move data from 1 database to another?

Actually, the database db2 has all ready been created, plus the table names are the same, so I can not use pg_dump and restore. INSERT INTO db1.public.tables SELECT * FROM db2.public.table1 Thanks, Thomas From: "scott.marlowe" <[EMAIL PROTECTED]> To: Thomas LeBlanc <[E

[GENERAL] How to move data from 1 database to another?

I have 2 databases. I want to move data from table table1 in database db1 to table2 in db2. When I query 1 table from another database, I get a cross-database references are not implemented. server1% psql db1 emdata=# select * from db2.public.table1; ERROR: Cross-database references are not im

[GENERAL] Constrint Name Length...

What is the maximum length a constraint name can be? Example, Foreign Key constraint name (FK_Table1Field1_Table2Field1). Thanks, ThomasLL _ Mother’s Day is May 9. Make it special with great ideas from the Mother’s Day Guide! http://s

[GENERAL] Calls to find Users and databases open...

What are the SQL commands to find who is logged on a server, what database he/she has open, etc? Where is this information in the help file or documentation? Thanks, Thomas _ FREE pop-up blocking with the new MSN Toolbar – get it now

[GENERAL] Does an index get create for a Primary Key?

Does an index get created for a Primary Key or is it just a constraint? Thanks, ThomasLL _ Free up your inbox with MSN Hotmail Extra Storage. Multiple plans available. http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm0

[GENERAL] Loggin SQL Statements from JBOSS/JDBC

Are there settings in PostgreSQL to log SQL Statements from client apps? Is yes, where are they logged to? We set log_statement=On, but where does the log get sritten to? Thanks, Thomas LeBlanc _ MSN Shopping upgraded for the

Re: [GENERAL] Loggin SQL Statements from JBOSS/JDBC

Where are the log files written? Thanks, Thomas LeBlanc From: Richard Huxton <[EMAIL PROTECTED]> To: "Thomas LeBlanc" <[EMAIL PROTECTED]>,[EMAIL PROTECTED] Subject: Re: [GENERAL] Loggin SQL Statements from JBOSS/JDBC Date: Fri, 14 Nov 2003 17:07:37 + On Friday 14 Novem

[GENERAL] Execute Function from VB/ADO

, 'Anniston', 'real') AS gLIBB(binid timestamp, sitename varchar, exerciseid varchar, datetimestamp timestamp, issuancetime timestamp) How can I execute this from a ADO connection? Thomas LeBlanc _ Fa

[GENERAL] Unique Index vs. Unique Constraint

Does a Unique Constraint build a unique index? What is the difference? Thanks, Thomas LeBlanc _ Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963