[GENERAL] RE: Importing into Postgres from a csv file

- Mensaje original - De: "Jake" <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviado: miércoles, 23 de agosto de 2000 21:56 Asunto: [GENERAL] Importing into Postgres from a csv file > Does any one know if this is possible, and if so how? Use copy command: COPY table FROM 'data.csv'

[GENERAL] JDBC

Hi, I've installed PostgreSQL 7.02 RPM Version with it's JDBC package RPM, now i'm trying to run my java application that connects to postgresql. driver: postgresql.Driverand connection: jdbc:postgresql:mydb I got errors saying class not found. i tried to check for

VS: [GENERAL] JDBC

Hi, I've installed PostgreSQL 7.02 RPM Version with it's JDBC package RPM, now i'm trying to run my java application that connects to postgresql. driver: postgresql.Driverand connection: jdbc:postgresql:mydb I got errors saying class not found. i tried to check for the file po

Re: [GENERAL] Importing into Postgres from a csv file

I think that you can do this using the COPY verb in psql. COPY table FROM file USING DELIMITERS ','; Just be sure that the order of the data in the file is the same as the order of the variables in the table. John On Wed, 23 Aug 2000, Jake wrote: > Does any one know if this is possible, and

Re: FW: [GENERAL] Count & Distinct

I'm confused, your SELECT uses the variable "row", but there is no such variable in your table? John On Thu, 24 Aug 2000, anuj wrote: > > > > >>> select count(distinct(row)) from table; > hi, > I have also tried but I am geting an error. > > *** > tempdb=> \d tbltemp > Table=

Re: [GENERAL] Importing into Postgres from a csv file

John McKown wrote: > > I think that you can do this using the COPY verb in psql. > > COPY table FROM file USING DELIMITERS ','; > > Just be sure that the order of the data in the file is the same as the > order of the variables in the table. > > John > > On Wed, 23 Aug 2000, Jake wrote: > > D

[GENERAL] Postgresql on Solaris 8

Has anyone tried running postgres with Solaris 8? Are there any make - install issues that I should be aware of? Thanks for your help. Jeff Seaman

Re: FW: [GENERAL] Count & Distinct

I find that if I create the table described in the email, in psql I recieve 'ERROR: Attribute 'row' not found'... But this isn't exactly 'ERROR: parser: parse error at or near "distinct"'... - Original Message - From: "John McKown" <[EMAIL PROTECTED]> To: "anuj" <[EMAIL PROTECTED]> Cc

[GENERAL] No Suitable Driver

Hi, I got my servlet work but i'm getting error saying No Suitable Driver in my JDBCConnectionPool. why is that so? what could be wrong? I had tested it on oracle under windows it works fine, now in Redhat linux with postgres, i got that error. jackson

Re: FW: [GENERAL] Count & Distinct

On Thu, Aug 24, 2000 at 10:35:49AM -0700, Ryan Williams wrote: > I find that if I create the table described in the email, in psql I recieve > 'ERROR: Attribute 'row' not found'... > > But this isn't exactly 'ERROR: parser: parse error at or near > "distinct"'... Right, that's the error you ge

Re: [GENERAL] Importing into Postgres from a csv file

On Thu, 24 Aug 2000, John McKown wrote: > I think that you can do this using the COPY verb in psql. > > COPY table FROM file USING DELIMITERS ','; Be aware you will probably have to start psql as the postgres (superuser) to use the COPY command. But ... the \copy version is usable by normal us

Re: FW: [GENERAL] Count & Distinct

I'm running 7.0.2 (or at least I believe so). Is there something that /I/ may be doing wrong? - Original Message - From: "Ross J. Reedstrom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 24, 2000 8:44 AM Subject: Re: FW: [GENERAL] Count & Distinct > On Thu, Aug 24,

Re: [GENERAL] JDBC

-- Peter T Mount [EMAIL PROTECTED], [EMAIL PROTECTED] Homepage: http://www.retep.org.uk Contact details: http://petermount.com PostgreSQL JDBC: http://www.retep.org.uk/postgres/ Java PDF Generator: http://www.retep.org.uk/pdf/ - Original Message - From: "Jackson Ching" <[EMAIL PROTECTED]

Re: [GENERAL] No Suitable Driver

Ah servlets. The CLASSPATH variable doesn't work with them. Copy the .jar file into the JDK's lib/jre/ext directory, and it should then work. Peter -- Peter T Mount [EMAIL PROTECTED], [EMAIL PROTECTED] Homepage: http://www.retep.org.uk Contact details: http://petermount.com PostgreSQL JDBC: htt

Re: [GENERAL] Importing into Postgres from a csv file

On Thu, 24 Aug 2000, Roderick A. Anderson wrote: > On Thu, 24 Aug 2000, John McKown wrote: > > > I think that you can do this using the COPY verb in psql. > > > > COPY table FROM file USING DELIMITERS ','; > > Be aware you will probably have to start psql as the postgres (superuser) > to use t

Re: FW: [GENERAL] Count & Distinct

Yeah, There is no column 'row'. You're trying to use 'row' as the value expression. Postgres figures it's a column reference and tries to find it (and doesn't). ::= [] Set function type is COUNT, set quantifier is DISTINCT, 'row' is not a valid value expression in this case. Note also,

[GENERAL] User security on tuple level

Hi, I need to implement security on the tuple level, so that certain "users" only have access to certain rows within a table. When I was working with Oracle I implemented this type of security by creating a logon trigger which called a function. This function set a context (Oracle object som

Re: [GENERAL] Problem with rules & ODBC

Have you tried this with triggers? I've never done this w/rules, but with triggers, I don't have this problem. -- Joel Burton, Director of Information Systems -*- [EMAIL PROTECTED] Support Center of Washington (www.scw.org)

Re: [GENERAL] Count & Distinct

Yup.. I (original poster) am using 6.5.3 and should/would/will head to 7.0.2 (already on another site in production). Just waiting for the time/need. Thanks to everyone for their help. J > From: "Ryan Williams" <[EMAIL PROTECTED]> > Date: Thu, 24 Aug 2000 12:08:46 -0700 > To: <[EMAIL PROTECTED]

[GENERAL] ECPG and SQL function

Hi, I wrote a sql funtion which accept 1 varchar in and return an int4. I try to use this function in a C program with ECPG. The command : "exec sql select myfunction('myargument') into :res" works fine but : "mycommand=select myfonction('mychangingargument') sql prepare myprep from mycomma

[GENERAL] Still No Suitable Driver

Hi, Thanks for the answers before. But i still have the same problem. i don't know why. i have put jdbc7.0-1.2.jar in /opt/IBMJava2-13/jre/ext and /opt/IBMJava2-13/jre/lib already and put them in the CLASSPATH=$CLASSPATH:/opt/IBMJava2-13/jre/ext/jdbc7.0-1.2.jar I als

Re: [GENERAL] Importing into Postgres from a csv file

> On Thu, 24 Aug 2000, Roderick A. Anderson wrote: > > > On Thu, 24 Aug 2000, John McKown wrote: > > > > > I think that you can do this using the COPY verb in psql. > > > > > > COPY table FROM file USING DELIMITERS ','; > > > > Be aware you will probably have to start psql as the postgres (sup

Re: [GENERAL] Great Bridge re-runs benchmark with MySQL "tuned"

Hi! > "Poul" == Poul L Christiansen <[EMAIL PROTECTED]> writes: Poul> It would be interesting to see how well PostgreSQL performed when it was Poul> tuned. Poul> Or has it allready been tuned? Yes, it was. According to Ned, they did run vacuum() on the tables before running the test and

[GENERAL] Stupid database use the index!

Postgres 7.0.2 on linux. Why is this? web=# explain select account_nbr from apprsl_accounts where account_nbr = 3315; NOTICE: QUERY PLAN: Seq Scan on apprsl_accounts (cost=0.00..10317.24 rows=1 width=8) EXPLAIN web=# explain select account_nbr from apprsl_accounts where account_nbr = '3315'

Re: [GENERAL] some problems

Roodie <[EMAIL PROTECTED]> writes: > ERROR: ExecEvalExpr: unknown expression type 108 Sub-selects in constraint expressions don't work at the moment :-(. An easy workaround is to put the sub-select in a function and call the function from your constraint. regards, tom la

[GENERAL] enum datatype?

Hey, I checked in the documentation, and couldn't find any reference to it. But I was wondering wether it is possible to create some kind of work around, or if there is actually an enum type. Cheers = Philip Murrayhttp://www.ope

Re: [GENERAL] Stupid database use the index!

> Why is this? > > web=# explain select account_nbr from apprsl_accounts where account_nbr = > 3315; > NOTICE: QUERY PLAN: > > Seq Scan on apprsl_accounts (cost=0.00..10317.24 rows=1 width=8) > > EXPLAIN > web=# explain select account_nbr from apprsl_accounts where account_nbr = > '3315'; > N

[GENERAL] 2-phase commit

Hello, Is there any open source implementation of 2-phase commit out there using Postgres ? The basic logic says : MASTERSLAVE --- begin atomic action send request 1-n send "prepare to commit message"

Re: [GENERAL] sorting in UNICODE table

> I'm use postgresql-7.0.2. It's compiled with unicode support > (./configure --enable-multibyte=UNICODE ...) > I have a table which contains both latin and non-latin letters. All they are in >UTF-8 encoding. When > I try to sort the rows > > ( SELECT * FROM my_table ORDER BY sort_field ) > > I

[GENERAL] sorting in UNICODE table

Hi, I'm use postgresql-7.0.2. It's compiled with unicode support (./configure --enable-multibyte=UNICODE ...) I have a table which contains both latin and non-latin letters. All they are in UTF-8 encoding. When I try to sort the rows ( SELECT * FROM my_table ORDER BY sort_field ) I receive str