Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

On 09/10/2013, at 11:03 PM, Tony Theodore wrote: > On 09/10/2013, at 8:39 PM, raghu ram wrote: >> >> ETL Tools for PostgreSQL:: >> >> Definition: An ETL process data to load into the database from a flat file >> >> A. Extract >> B. Transform >> C. Load > > Not exactly an ETL tool, but I've

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

On 09/10/2013, at 8:39 PM, raghu ram wrote: > > On Mon, Oct 7, 2013 at 8:32 PM, sunpeng wrote: > Hi, Friends, are there any ETL tools (free or commercial) available for > PostgreSQL? > > > ETL Tools for PostgreSQL:: > > Definition: An ETL process data to load into the database from a flat

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

On Mon, Oct 7, 2013 at 8:32 PM, sunpeng wrote: > Hi, Friends, are there any ETL tools (free or commercial) available for > PostgreSQL? > > *ETL Tools for PostgreSQL::* Definition: An ETL process data to load into the database from a flat file A. Extract B. Transform C. Load 1. PGLoader - Load

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

http://kettle.pentaho.com/ works pretty good to. On Mon, Oct 7, 2013 at 11:39 AM, Michal TOMA wrote: > Talend? > http://talend.com/ > But usually all major ETL tools do work with any database including > PostgreSQL > > On Monday 07 October 2013 17:54:36 Vick Khera wrote: > > http://lmgtfy.com/

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

Talend? http://talend.com/ But usually all major ETL tools do work with any database including PostgreSQL On Monday 07 October 2013 17:54:36 Vick Khera wrote: > http://lmgtfy.com/?q=postgres+ETL+tools > > On Mon, Oct 7, 2013 at 11:02 AM, sunpeng wrote: > > Hi, Friends, are there any ETL tools (fr

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

Talend? http://talend.com/ But usually all major ETL tools do work with any database including PostgreSQL On Monday 07 October 2013 17:54:36 Vick Khera wrote: > http://lmgtfy.com/?q=postgres+ETL+tools > > On Mon, Oct 7, 2013 at 11:02 AM, sunpeng wrote: > > Hi, Friends, are there any ETL tools (fr

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

http://lmgtfy.com/?q=postgres+ETL+tools On Mon, Oct 7, 2013 at 11:02 AM, sunpeng wrote: > Hi, Friends, are there any ETL tools (free or commercial) available for > PostgreSQL? > Thanks! > peng >

Re: [GENERAL] Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"?

On 8/6/12 3:31 AM, Magnus Hagander wrote: On Mon, Aug 6, 2012 at 11:22 AM, sunpeng wrote: Hi,Frirends, Are there any commands in pgsql/bin/ corresponding "create tablespace"? I know: createuser<==> create role createdb<==>create database Hi! No, but you can always use: psql -c

Re: [GENERAL] Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"?

On Mon, Aug 6, 2012 at 11:22 AM, sunpeng wrote: > Hi,Frirends, > Are there any commands in pgsql/bin/ corresponding "create tablespace"? > I know: > createuser <==> create role > createdb <==>create database Hi! No, but you can always use: psql -c "create tablespace foo..." -- Magnus

Re: [GENERAL] Hi,are there any other open source parallel query engine like pgpool?

Hello http://www.postgresql.org/about/news/1351/ Regards Pavel Stehule 2012/2/8 sunpeng : > Hi,Friends, >   I would like to study parallel query, also hope to implement a parallel > db, are there any other open source parallel query engine like pgpool? >   Thanks! > peng -- Sent via pgsql-gen

Re: [GENERAL] hi, friends. are there any performance tuning materials for postgreSQL recommended?

On Mon, Oct 24, 2011 at 9:38 PM, Craig Ringer wrote: > On 25/10/11 11:00, sunpeng wrote: > > Hi, friends. >  Are there any performance tuning resouces for postgreSQL recommended, such > as ppt, books or articles? > Thanks! > peng > > http://wiki.postgresql.org/wiki/Performance_Optimization > > htt

Re: [GENERAL] hi, friends. are there any performance tuning materials for postgreSQL recommended?

On 25/10/11 11:00, sunpeng wrote: > Hi, friends. > Are there any performance tuning resouces for postgreSQL recommended, > such as ppt, books or articles? > Thanks! > peng http://wiki.postgresql.org/wiki/Performance_Optimization http://www.postgresql.org/docs/books/ ... of which the most recent

Re: [GENERAL] hi, how to let the inserted tuple visible to other backend when current backend hasn't finish?

On Sun, Sep 12, 2010 at 3:02 AM, sunpeng wrote: > hi, These codes are in the postgresql engine, just assume they are in > PortalRun() function: > //1.create table structure > char *relname = "test"; > ... > relOid = heap_create_with_catalog(relname, ); > CommandCounterIncrement(); > ... > //2.

Re: [GENERAL] hi,i write a function in postgresql source code, how to register this function?

sunpeng writes: > hi,i write a function in postgresql source code, how to register this > function? See src/include/catalog/pg_proc.h But you should *really* consider making it a loadable module. That's the way it makes sense for any code you want to add in the server unless you're preparing a

Re: [GENERAL] hi,i write a function in postgresql source code, how to register this function?

Hi, On Wednesday 16 June 2010 18.42:25 sunpeng wrote: > hi,i write a function in postgresql source code, how to register this > function? > it is not an aggregate function. > i don't use 34.3"User-Defined Functions" described in > http://www.postgresql.org/docs/8.4/interactive/xfunc.html, i just w

Re: [GENERAL] hi,i write a function in postgresql source code, how to register this function?

It's just in postgresql 8.4 source code,e.g in /backend/executor/functions.c, not in sql,not in pl/pgsql 2010/6/16 Raymond O'Donnell > On 16/06/2010 17:42, sunpeng wrote: > > hi,i write a function in postgresql source code, how to register this > > function? > > it is not an aggregate function.

Re: [GENERAL] hi,i write a function in postgresql source code, how to register this function?

On 16/06/2010 17:42, sunpeng wrote: > hi,i write a function in postgresql source code, how to register this > function? > it is not an aggregate function. > i don't use 34.3"User-Defined Functions" described in > http://www.postgresql.org/docs/8.4/interactive/xfunc.html, i just write > it in postgr

[GENERAL] Re: [GENERAL] Re: [GENERAL] hi，for help!

hi ,it turn out i indeed deleted the postgres , and with the command "psql template1 create database postgres; " i got my postgres. Scott , Ashesh ,thanks for your both help . 2010/5/30 Scott Marlowe > On Sat, May 29, 2010 at 6:35 PM, zhenyang guo > wrote: > > hi ,i got a problem , kinda

[GENERAL] Re: [GENERAL] Re: [GENERAL] hi，for help!

On Sat, May 29, 2010 at 6:35 PM, zhenyang guo wrote: > hi ,i got a problem , kinda don't know how to deal with it ,hoping can get > help here ,thanks ! >  also to Ashesh  ,firstly, thanks for every favor you did. and  the postgres > must exist ,maybe just present itself for some reason. when i giv

[GENERAL] Re: [GENERAL] hi，for help!

Hi, Looks like, you accidentally deleted the postgresql database. It can work without the postgres database, you just need to specify the database name to work with. i.e. psql test1 -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On

[GENERAL] Re: [GENERAL] hi，for help!

hi ,i got a problem , kinda don't know how to deal with it ,hoping can get help here ,thanks ! also to Ashesh ,firstly, thanks for every favor you did. and the postgres must exist ,maybe just present itself for some reason. when i give the command " psql -l template1 " it was there. <<<

[GENERAL] Re: [GENERAL] hi，for help!

[Adding pgsql-general...] Please CC to pgsql-general.. (Use reply-all...) On Sat, May 29, 2010 at 2:31 PM, zhenyang guo wrote: > hi,Ashesh, i did as you said ,it still gives problem. information from the > terminal is following: > > " postg...@guo-desktop:~$ psql -l > > psql: FATAL: databa

[GENERAL] Re: [GENERAL] hi，for help!

What is the output of the following commands? psql -l psql --version -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On Fri, May 28, 2010 at 7:11 PM, zhenyang guo wrote: > hi, i have a problem not knowing how to fix . the follwi

Re: [GENERAL] hi，for help!

You need to "initdb" first. Am Freitag, 28. Mai 2010 15:41:38 schrieb zhenyang guo: > hi, i have a problem not knowing how to fix . the follwing are error > information: > > " > g...@guo-desktop:~$ su > Password: > r...@guo-desktop:/home/guo# su - postgres > postg...@guo-desktop:~$ psql > psql:

Re: [GENERAL] hi，for help!

zhenyang guo wrote: > hi, i have a problem not knowing how to fix . the follwing are error > information: > > " > g...@guo-desktop:~$ su > Password: > r...@guo-desktop:/home/guo# su - postgres > postg...@guo-desktop:~$ psql > psql: FATAL: database "postgres" does not exist > postg...@guo-desk

Re: [GENERAL] hi, trying to compile postgres 8.3.11

erobles wrote: >> Do you need the Pg server to run on SCO OpenServer? > > Yes, i need it :-P Of course it's none of my business, but whenever I had a supplier insisting on some idosyncratic or obsolete OS I started thinking hard about replacing the supplier and their product. Even worse if

Re: [GENERAL] hi, trying to compile postgres 8.3.11

On 05/27/2010 10:29 AM, Craig Ringer wrote: On 27/05/2010 10:42 PM, erobles wrote: hi, i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7 Possibly stupid question: Why? Do you need the Pg server to run on SCO OpenServer? Yes, i need it :-P Before i have running pg 7.2 after we

Re: [GENERAL] hi, trying to compile postgres 8.3.11

On 27/05/2010 10:42 PM, erobles wrote: hi, i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7 Possibly stupid question: Why? Do you need the Pg server to run on SCO OpenServer? Or just a client? Have you considered running your (presumably SCO-based) client with a network connection

Re: [GENERAL] hi, trying to compile postgres 8.3.11

erobles writes: > i have been using gcc 2.95.2 to compile At least get onto 2.95.3 ;-). I've been using that version on HPPA for quite awhile and haven't tripped across any bugs. But in any case these are stone-age versions. regards, tom lane -- Sent via pgsql-

Re: [GENERAL] hi, trying to compile postgres 8.3.11

i have been using gcc 2.95.2 to compile On 05/27/2010 10:02 AM, Tom Lane wrote: erobles writes: i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7, but ... when the xlog.o is being compiled i have the next error: /usr/tmp/ccihgiYL.s: 1113: syntax error at name

Re: [GENERAL] hi, trying to compile postgres 8.3.11

erobles writes: > i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7, but ... > when the xlog.o is being compiled i have the next error: > /usr/tmp/ccihgiYL.s: 1113: syntax error at name f > /usr/tmp/ccihgiYL.s: 1113: syntax error at integer constant: 1 Looks like a compiler bug. Ge

Re: [GENERAL] hi, trying to compile postgres 8.3.11

On Thu, May 27, 2010 at 10:42 AM, erobles wrote: > hi, > i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7, but ... when > the xlog.o is being compiled  i have the next error: > > /usr/tmp/ccihgiYL.s: 1113: syntax error at name f > /usr/tmp/ccihgiYL.s: 1113: syntax error at integer consta

Re: [GENERAL] hi,is it dangerous to only use tuple pointer through heap_getnext()?

Excerpts from sunpeng's message of vie may 14 19:15:47 -0400 2010: > hi,i use these codes to store only pointer of tuple : > HeapTuple *tuple; > tuple = heap_getnext(pHeapScanDesc,ForwardScanDirection); > while(tuple){ > //[1#]here i only store the pointer of tuple in an array for l

Re: [GENERAL] hi all

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Grzegorz Jaśkiewicz wrote: > just outside of your question, you should read about normalization. > it is in general very bad idea to have a table that holds all > information possible . > I wouldn't say this table is not normalized. The only fields y

Re: [GENERAL] hi all

Kusuma Pabba wrote: when creating tables, in my sql i have used create table By "my SQL" I assume you mean MySQL? It took me a minute to figure out that you didn't mean "in my sql code" but rather "in the product MySQL". Having read your proposed table definition: I very strongly recommend

Re: [GENERAL] hi all

On Tue, Feb 17, 2009 at 5:54 AM, Kusuma Pabba wrote: > while in pgsql i am thinking of to use the same as follows: > > CREATE TABLE users ( > user_id int(11) NOT NULL serial, I see this construct in mysql all the time. Funny thing is most mysql users think it means an 11 character wide int, i.e

Re: [GENERAL] hi all

On Tue, Feb 17, 2009 at 04:40:58PM +, Sam Mason wrote: > > user_name varchar(50) NOT NULL, > > As a general design question; should user_name have a UNIQUE > constraint on it? i.e. > > user_name VARCHAR(50) NOT NULL UNIQUE, Yes, it's good to have a UNIQUE constraint, but not this one

Re: [GENERAL] hi all

a few further comments: On Tue, Feb 17, 2009 at 06:54:53PM +0530, Ashish Karalkar wrote: > CREATE TABLE users ( > user_id serial NOT NULL , It's common to combine this with the PRIMARY KEY constraint from below to be: user_id SERIAL PRIMARY KEY, the NOT NULL check is implicit in this and

Re: [GENERAL] hi all

Kusuma Pabba, 17.02.2009 13:54: while in pgsql i am thinking of to use the same as follows: CREATE TABLE users ( user_id int(11) NOT NULL serial, user_name varchar(50) NOT NULL, first_name varchar(50) default NULL, middle_name varchar(50) default NULL, last_name varchar(50) default NULL, p

Re: [GENERAL] hi all

Kusuma Pabba wrote: when creating tables, in my sql i have used create table CREATE TABLE `users` ( `user_id` int(11) NOT NULL auto_increment, `user_name` varchar(50) NOT NULL, `first_name` varchar(50) default NULL, `middle_name` varchar(50) default NULL, `last_name` varchar(50) default NUL

Re: [GENERAL] hi all

just outside of your question, you should read about normalization. it is in general very bad idea to have a table that holds all information possible . -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/p

Re: [GENERAL] Hi iam the beginner

Scott Marlowe wrote: > On Mon, Dec 15, 2008 at 11:02 PM, sai srujan wrote: >> Hi >> This is srujan and I am beginner of postgresql 8.1 and I have >> just stopped using mysql and i would like to use the dump (.sql file) >> created in it. I would like transfer the databases in my

Re: [GENERAL] Hi iam the beginner

On Dec 18, 2008, at 10:19 PM, Star Liu wrote: On Tue, Dec 16, 2008 at 2:02 PM, sai srujan wrote: Hi This is srujan and I am beginner of postgresql 8.1 and I have just stopped using mysql and i would like to use the dump (.sql file) created in it. I would like transfer the

Re: [GENERAL] Hi iam the beginner

On Tue, Dec 16, 2008 at 2:02 PM, sai srujan wrote: > Hi > This is srujan and I am beginner of postgresql 8.1 and I have > just stopped using mysql and i would like to use the dump (.sql file) > created in it. I would like transfer the databases in my sql to postgresql > 8.1. Ple

Re: [GENERAL] Hi iam the beginner

(sorry all, I *couldn't* resist!) Scott ... In all these years that's the 1st time I've ever 'heard' the term "massage you data" !!! All sorts of deviant thoughts come to your mind! LOL BR, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Friday 19 December 2008 12:03:26 am Scott Mar

Re: [GENERAL] Hi iam the beginner

On Mon, Dec 15, 2008 at 11:02 PM, sai srujan wrote: > Hi > This is srujan and I am beginner of postgresql 8.1 and I have > just stopped using mysql and i would like to use the dump (.sql file) > created in it. I would like transfer the databases in my sql to postgresql > 8.1. Pl

Re: [GENERAL] Hi there, new here and have question

|> |> -Original Message- |> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hendra |> Sent: 8 juillet 2008 02:59 |> To: pgsql-general@postgresql.org |> Subject: [GENERAL] Hi there, new here and have question |> |> Hi Everyone. |> I'm just subscribe to the mailing list |> I'm n

Re: [GENERAL] Hi there, new here and have question

CREATE OR REPLACE FUNCTION listofemployeebasedondepartment(_id_dept int) RETURNS SETOF record AS $BODY$ DECLARE empdata record; BEGIN RETURN QUERY SELECT e.*, d.department_name FROM employee e, dept d WHERE e.id_dept = d.id AND e.id_dept = _id_dept; RETURN; END; $BODY$ LANGUAGE 'plpg

Re: [GENERAL] Hi there, new here and have question

Any suggestion everyone? Sorry, i was to fast sending this email out ;-) change the first parameter in the first line to '_id_depth' CREATE OR REPLACE FUNCTION listofemployeebasedondepartment(_id_dept int) RETURNS SETOF employee AS $BODY$ BEGIN RETURN QUERY SELECT * F

Re: [GENERAL] Hi there, new here and have question

Hi Hendra, create function listofemployeebasedondepartment(id_dept int) $$ declare resultset ??; begin select * into resultset from employee where id_dept = id_dept; return resultset; end $$ language 'plpgsql'; I believe you get what I want But I just couldn't finish the code since I mi

Re: [GENERAL] Hi, For the UTF-8 encoding

patch?      -- Steve Yao       -原始邮件-发件人:"Martijn van Oosterhout" 发送时间:2006-10-04 17:42:00收件人:"stevegy" <[EMAIL PROTECTED]>抄送:pgsql-general@postgresql.org主题:Re: [GENERAL] Hi, everOn Wed, Oct 04, 2006 at 07:50:12AM +0800, stevegy wrote: > My testing database is

Re:  [GENERAL] Hi, ever

On Wed, Oct 04, 2006 at 07:50:12AM +0800, stevegy wrote: > My testing database is initdb -E UTF8. And i guess the solaris can > not handle the UTF-8 sorting with the LC_COLLATE="zh_CN.GB18030". But > i need to prove this. A locale can only handle one charset, usually the one given by "locale char

Re:  [GENERAL] Hi, ever

.I think I post 2 questions in one post and it's a bad idea. So I post another mail for the convert function error.Thank you and have a nice day.-- Steve Yao -原始邮件-发件人:"Martijn van Oosterhout" 发送时间:2006-10-03 21:51:25收件人:"stevegy" 抄送:pgsql-general@

Re: [GENERAL] Hi, everyone. can i ask a question for th e server side encoding GB18030 and sort order?

On Tue, Oct 03, 2006 at 04:16:36PM +0800, stevegy wrote: > I have published my application since a month and I notice the appcation > server report a few jdbc errors that says : > org.postgresql.util.PSQLException: ERROR: character 0xe28094 of encoding > "UTF8" has no equivalent in "EUC_CN" > I t

Re: [GENERAL] hi, what is wrong with my newbie sql?

"Ronin" <[EMAIL PROTECTED]> writes: > k = 10; > FOR k IN 1..10 LOOP > k = k +1; > END LOOP; > return k; An integer for-loop implicitly declares its control variable, so the "k" inside the loop is unrelated to the "k" ou

Re: [GENERAL] hi, what is wrong with my newbie sql?

Ronin <[EMAIL PROTECTED]> schrieb: > Hi, the following sql returns "10" and not "20" as would be expected. > > Where is the error? This would for sure work in any programming > language, why is this different? > > CREATE FUNCTION test () RETURNS INTEGER AS ' > > DECLARE > k

Re: [GENERAL] Hi,

On Thu, 2006-03-23 at 13:03, Brian Kitzberger wrote: > Hi Tom, > > I decided to test your theory that I had an old version of Postgres on > my system when I installed version 8.1.3. By the way, the Linux install > we a fresh one to start with. So this morning I first did a search on OK, assumin

Re: [GENERAL] Hi,

Brian Kitzberger wrote: Hi Tom, I decided to test your theory that I had an old version of Postgres on my system when I installed version 8.1.3. By the way, the Linux install we a fresh one to start with. So this morning I first did a search on my system for all pg_dump files, and wrote the lo

Re: [GENERAL] Hi,

Hi Tom, I decided to test your theory that I had an old version of Postgres on my system when I installed version 8.1.3. By the way, the Linux install we a fresh one to start with. So this morning I first did a search on my system for all pg_dump files, and wrote the locations down. I them remo

Re: [GENERAL] Hi,

"Brian Kitzberger" <[EMAIL PROTECTED]> writes: > When I did I get "pg_dump: server version: 8.1.3; pg_dump version: > 7.4.8" Apparently you already had a 7.4.8 postgres installed on your machine. Most versions of Linux do have PG in them. You probably want to remove the 7.4.8 files to avoid con

Re: [GENERAL] hi problem with installing postgresql8.1

Firstly, the existence of the Path would be there from previous installation, of which PG thinks data is already present. Secondly you should have logged in as another user and not administrator, e.g postgres which can be even a part of domain.   Luckys   Data directory error:  The specified data

Re: [GENERAL] hi problem with installing postgresql8.1

venu gopal schrieb: > Hi all, > I am new to pgsql family.I had a problem with > installing postgres8.1 i was getting the following > error at the 4th step of installation the error is as > follows: > > Data directory error: > The specified data directory is not empty > >If you have an e

Re: [GENERAL] hi all......................!!

AKHILESH GUPTA schrieb: > hello everybody > i am new to this mailing list. this is my first mail to this group. > i jussst want to confirm that whether is it possible to update a view or > not?? > i think you all help me in solving my queries in future...!! Yes it is. All you have

Re: [GENERAL] Hi

Alexander Lohse <[EMAIL PROTECTED]> writes: > What would I need to do to run 2 Versions of Postgres on the RaQ3? Should be the same deal as for running 2 versions anyplace else: give them separate install directories, separate data directories, and separate port numbers. If you compile from sour