Re: [SQL] copy into serial field with auto_increment

Andy wrote: >i've got a textfile of data separated by '|'. One of the fields in my >table is a serial (auto_increment) field. >When i import the data with the copy command i get duplicate key error. >The key is the serial - field. >I recognized that the copy command doesn't auto_incremen

Re: [SQL] function to format floats as money? (removing space padding)

Now that I've figured out that numeric is good for storing money, and that I can format with like this: to_char(price, '9,999,999.99') as price Then I discovered that sometimes this returns leading spaces I don't want. I can get rid of them like this: trim(to_char(price, '9,999,999.99')) as pr

[SQL] Re: Postgresql to Access

On Thu, 19 Apr 2001, Mateusz Mazur wrote: > Hello. > > Could you help me? I have database in psql and my boss want to have this > base also is MS Access (only like client - main base will be psql). He wants > to use access like viewer to psql base. What should I do. You can create a front-end u

Re: [SQL] Postgresql to Access

On the MS Access box you can install the PostgreSQL Windows ODBC drivers that connect to the psql base. In Access you can link to the PostgreSQL ODBC and the you have a link to PostgreSQL from Access. You can the use the link (almost) like an ordinary MS Access table. Windows ODBC drivers are a

Re: [SQL] any proper benchmark scripts?

On Wed, Apr 18, 2001 at 07:00:24PM -0700, Clayton Cottingham aka drfrog wrote: "Benchmarks" comparing MySQL to anything else usually make the worst and lowest denominator compromise (which obviously favours MySQL). - What table types did you use on MySQL? Did you use the

Re: [SQL] Postgresql to Access

On Thu, Apr 19, 2001 at 03:43:30PM +0200, Mateusz Mazur wrote: > Hello. > > Could you help me? I have database in psql and my boss want to have this > base also is MS Access (only like client - main base will be psql). He wants > to use access like viewer to psql base. What should I do.

Re: [SQL] any proper benchmark scripts?

Thomas Good wrote: > > On 18 Apr 2001, Clayton Cottingham aka drfrog wrote: > > > i will recomp both the newest postgresql and mysql > > not using any optimizing techs at all i'll post the > > config scripts i use > > Hiya Clayton, > > Try it with a few hundred thousand tuples in a good size

Re: [SQL] any proper benchmark scripts?

Justin Clift wrote: > > Hi Clayton, > > Was it opening a new connection to the database every time, or did it > open one connection each time and pump multiple queries through it? > > It would be a good things to develop your script and benchmark this both > ways. Could become a useful tool fo

[SQL] Postgresql to Access

Hello. Could you help me? I have database in psql and my boss want to have this base also is MS Access (only like client - main base will be psql). He wants to use access like viewer to psql base. What should I do. Big Thanx for any sugestion. Mateusz Mazur ---(end of b

[SQL] Re: [GENERAL] Where are the 7.1 RPM's?

Lonnie Cumberland wrote: > Do anyone know where the 7.1 RPM's are so that I can install them? ftp://ftp.postgresql.org/pub/binary/v7.1/RPMS. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 5: Have you checked our extensi

[SQL] copy into serial field with auto_increment

Hello, i've got a textfile of data separated by '|'. One of the fields in my table is a serial (auto_increment) field. When i import the data with the copy command i get duplicate key error. The key is the serial - field. I recognized that the copy command doesn't auto_increment the serial field.

[SQL] Postgres book

Hello. I wonder if anyone have PostgreSQL: Introduction and Concepts by Bruce Momjian in pdf version. I will be very greatfull for any news. Mateusz Mazur [[EMAIL PROTECTED]] ---(end of broadcast)--- TIP 2: you can get off all lists at once with

Re: [SQL] any proper benchmark scripts?

On 18 Apr 2001, Clayton Cottingham aka drfrog wrote: > i will recomp both the newest postgresql and mysql > not using any optimizing techs at all i'll post the > config scripts i use Hiya Clayton, Try it with a few hundred thousand tuples in a good size table with say 300 users banging on th

[SQL] windows version

Is there a downloadable version of postgres for Windows NT??. Thanx in advance padmajha ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] any proper benchmark scripts?

Hi Clayton, Was it opening a new connection to the database every time, or did it open one connection each time and pump multiple queries through it? It would be a good things to develop your script and benchmark this both ways. Could become a useful tool for sizing both of these databases. Ou

Re: [SQL] groups in postgres

On Jue 19 Abr 2001 11:12, Richard Huxton wrote: > Martín Marqués <[EMAIL PROTECTED]> said: > > I building an application that will load data on a database by lots of > > people. So I thought about putting them in a group and giving priviledges > > to the group. > > > > The problem is the the infor

Re: [SQL] groups in postgres

Martín Marqués <[EMAIL PROTECTED]> said: > I building an application that will load data on a database by lots of > people. So I thought about putting them in a group and giving priviledges to > the group. > > The problem is the the information on the main table is related with fields > of ot