Re: [SQL] 1 milion data insertion

2002-07-26 Thread Marc Spitzer
On Fri, Jul 26, 2002 at 03:34:12PM -0300, Elielson Fontanezi wrote: > Hi fellows! > > I have tried to insert 1.000.000 of record to the following table; > > -- > zakal=# \d teste; > codigo | bigint | not null > nome | char

Re: [SQL] RES: [GENERAL] set DateStyle to 'SQL'

2002-07-26 Thread Roberto Mello
On Fri, Jul 26, 2002 at 01:56:16PM -0300, Elielson Fontanezi wrote: > The environment variables PGHOST and PGPORT specify to client applications > the host and port of the database server, overriding the compiled-in > defaults. If you are going to run client applications remotely then it is > con

Re: [SQL] Using Tables from another database.

2002-07-26 Thread D'Arcy J.M. Cain
* Reinoud van Leeuwen <[EMAIL PROTECTED]> [020726 08:05]: > On Thu, 25 Jul 2002 17:02:44 + (UTC), [EMAIL PROTECTED] > (Rogério Baldini das Neves) wrote: > >create view view_test as select * from mydb.mytable; > > This is possible in Sybase or Microsoft SQL server, not in Postgresql > (AFAIK)

[SQL] set DateStyle to 'SQL'

2002-07-26 Thread Elielson Fontanezi
Hi folks! There are a buch of varibles like DateStyle. I am interested to set them all in script shell. I've tried in postgresql.conf, but I could not. I've tried in shell environment, but it did not work. So, how can I do that? ..

[SQL] Numeric Style format

2002-07-26 Thread Elielson Fontanezi
Hi! Is there any way to format data type NUMERIC values as I can do with data type DATE using DateStyle. For example, I want to type numeric values typing: "1.000,23" rather than "1,000.23". regards, .. A Question... Since befor

[SQL] RES: [GENERAL] set DateStyle to 'SQL'

2002-07-26 Thread Elielson Fontanezi
Hi friends! Maybe I have not been clear. See, there are varibles like PGPORT, PG_HBA_SAMPLE, POSTGRES_BKI, POSTGRESQL_CONF_SAMPLE and much more. Where ca I find related information to them? and list of all them? my regards, E.F.:> -Mensagem original- E.F.