RE: [GENERAL] Selecting field names?

Enclosed please find a sample: cfmg_am=> select attname, typname from pg_attribute, pg_type, pg_class cfmg_am-> where relname = 'pgt_processing' cfmg_am-> and attrelid = pg_class.oid cfmg_am-> and atttypid = pg_type.oid; attname | typname +---

[GENERAL] PostgreSQL versus Oracle

Hello, Does anybody have ever heard about PostgreSQL vs Oracle performance tests and bibliography? Thanks Guillaume Perréal Stagiaire MIAG Cemagref - URH Tél: 04.72.20.87.64  

[GENERAL] BLOB datatype

i have created a table having blob object but now i am  not able to insert a picture into the table. Can you send me sql command to insert picture into the table i need syntax. i tried through DB2IMAGE but failed to insert.   if there is any other method of putting image in the table, kindly

Re: [GENERAL] OID rollover?

On Sun, 9 Apr 2000, Charles Martin wrote: > What happens to my database when the OID rolls over? A simple-minded calculation yields that you would have to create about 1 million new (not updated) records every day for more than 10 years to exhaust the oid space. By the time that becomes a proble

[GENERAL] pg_group table's grolist field

Hello I have just typed : "\d pg_group;" It said grolist field type: int4[], length var How can I create fields like grolist? What's to correct name of that field type wich used by the grolist field too? Thanks for any infos Regards Balazs

[GENERAL] need a help

Hi, I'm using PostgreSQL for an year and I'm very impressed with it. I have read all documentation included in RPM archieve but I found nothing about functions subst, ltrim, pg_get_userbyid etc.. Please, would you tell me where can I find any documentation about this subject. Thanks

Re: [GENERAL] Permission denied while importing data from a file?

I've gotten that message before when users couldn't read the directory the file is in. -- Adam Ruth InterCation, Inc. www.intercation.com "Felix Slager" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > LS, > > i'm trying to copy data into a table using a copy co

Re: [GENERAL] Minor hack to support LO string searches

> Hi, all, at > > http://www.idyll.org/~t/www-tools/ > > you'll find an add-on function to PostgreSQL 6.5.3 that allows one to > do string searches through large objects. > > It's not a terribly good hack, but it works ;). > > I do plan on extending this add-on to support regular express

Re: [GENERAL] need a help

Anton Kalauzky wrote: > > ... I have > read all documentation included in RPM archieve but I found nothing > about functions subst, ltrim, pg_get_userbyid etc.. > Please, would you tell me where can I find any documentation about this > subject. http://www.postgresql.org/docs/faq-english.html#

Re: [GENERAL] recursive queries?

> Personally, I'm really only interested in something elegant. Meaning I > don't want to mess around with a solution where this broker communicates > with that broker via an n-way blah blah blah. I can maintain literacy > in several tools at once, but not several dozen. Is my best bet simply >

RE: [GENERAL] BLOB datatype

look at the examples in the postgresql book available on the website. krishna -Original Message- From: iqbal [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 7:11 AM To: [EMAIL PROTECTED] Subject: [GENERAL] BLOB datatype i have created a table having blob object but now i am

RE: [GENERAL] Permission denied while importing data from a file?

maybe the directory '.../somebody' does not have read permission (700?) krishna -Original Message- From: Adam Ruth [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 9:54 AM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] Permission denied while importing data from a file? I've got

RE: [GENERAL] Re: newline character handling

maybe we need a keyword DOS|UNIX or perhaps TEXT|BINARY to tell postgresql to pick DOS style or UNIX style line endings... krishna -Original Message- From: Michael Blakeley [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 08, 2000 12:57 PM To: [EMAIL PROTECTED] Subject: [GENERAL] Re: n

Re: [GENERAL] Re: newline character handling

> maybe we need a keyword DOS|UNIX or perhaps TEXT|BINARY to tell postgresql > to pick DOS style or UNIX style line endings... Maybe we just need to make sure that the files we are using are in the correct format for the platform they're being processed on. ; ) steve

[GENERAL] Features

Hi Folks, I know this one has been asked alot, but since i can't search, i'm gonna re-ask. 1: Reliablility - is there any documents out there regarding stability and reliablilty of postgresql 2: replication - still in exotic list ? there is huge market demand, and lots of peopl

[GENERAL] Re: [NOVICE] installation question

On Sun, Apr 09, 2000 at 11:43:35PM -0400, Vipin Samtani wrote: -> hi, -> i am a novice user running Red Hat Linux Server 6. -> what files do i need to download to install PostGreSQL? -> vipin -> Have you checked to see if there is an RPM package on your RH CD? -- -- C^2 No

Re: [GENERAL] [NOVICE] installation question

Vipin Samtani wrote: > > hi, > i am a novice user running Red Hat Linux Server 6. > what files do i need to download to install PostGreSQL? > vipin ftp://ftp.postgreSQL.org/pub/postgresql-7.0beta5.tar.gz (it's beta, but it's best) Also, no need to blast all the lists with the question. pgsql

[t-ishii@sra.co.jp: Re: [GENERAL] Minor hack to support LO string searches]

This points out a need that I haven't really seen addressed -- a PG software contrib archive. Is there such a thing? Are there any objections to starting such a thing? cheers, --titus - Forwarded message from Tatsuo Ishii <[EMAIL PROTECTED]> - To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTE