I would recomend MS Access/ODBC.
It works very fine both with linked Excel spreadsheets and PostgreSQL
tables.
Therefore, you can easily automate data import from Excel to PostgreSQL via
Acess.
- Original Message -
From: "Steve Atkins" <[EMAIL PROTECTED]>
To: "pgsql-general General"
t: Wednesday, July 11, 2007 2:31 PM
Subject: Re: [GENERAL] odbc parameters
am Wed, dem 11.07.2007, um 14:15:02 +0200 mailte Zlatko Matic folgendes:
Hello,
please don't hijack other threads. If you only change the subject for a
new question, your mail will be sorted completely wrong.
(within
Hello,
I use MS Access for data import. Access imports csv file, make some
calculation and transffers data to PostgreSQL.
Unfortunately, it takes a lot of time to transfer data to PostgreSQL.
My odbc settings are following:
[ODBC]
DRIVER=PostgreSQL Unicode
UID=postgres
XaOpt=1
LowerCaseIdentif
Hello.
Is there any free program/utility for batch imports from .csv files, that
can be easily scheduled for daily inserts of data to PostgreSQL tables?
Regards,
Zlatko
---(end of broadcast)---
TIP 5: don't forget to increase your free space m
affected rows, so that after statement-level trigger
can read that information.
It works and is fast enough.
So, I emulated NEW and OLD for statement level trigger:)
Regards,
Zlatko
- Original Message -
From: hubert depesz lubaczewski
To: Zlatko Matic
Cc: pgsql-general
Does plpgsql has something equivalent to plperl $_SHARED or plpythonu global
dictionary GD?
Thanks,
Zlatko
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hello.
These days I was trying to temporarily disable triggers, too, and had much
problems with ALTER TABLE..DISABLE TRIGGER ALL. So, I was googling for another
solution and have found this: http://www.varlena.com/GeneralBits/101.php. Works
OK in my case...
Turn off triggers for bulk
Hello.
Is it possible to retrieve information about how many rows were
changed/inserted in a table that fired after statement trigger?
Thanks,
Zlatko
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
unsubscribe
Have you tried to restore just schema first, then data?
Greetings,
Zlatko
- Original Message -
From: "Howard Cole" <[EMAIL PROTECTED]>
To: "'PgSql General'"
Sent: Friday, December 02, 2005 3:02 PM
Subject: [GENERAL] Unicode Corruption and upgrading to 8.0.4. to 8.1
Hi everyone, I ha
thanks for information
- Original Message -
From: "Matthew T. O'Connor"
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: "Magnus Hagander" <[EMAIL PROTECTED]>; "Marc G. Fournier"
<[EMAIL PROTECTED]>;
Sent: Tuesday, October 25
what is the schedule for releasing first official 8.1 ?
- Original Message -
From: "Magnus Hagander" <[EMAIL PROTECTED]>
To: "Marc G. Fournier" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, October 24, 2005 8:04 PM
Subject: Re: [GENERAL] [ANNOUNCE] PostgreSQL 8.1 Beta 4
>> In order to addr
No, I didn't try ident authentication...
It seems to me that security issues should be passd to client company's
system administrator ?
- Original Message -
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
No, I'm on Windows...
- Original Message -
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>
Cc: "Zlatko Mati?" <[EMAIL PROTECTED]>; "Matthew T. O'Connor"
;
Sent: Wednesday, October 12, 2005 1:14 AM
Subject: Re: [GENERAL] user privilages for executing pg_aut
If I put password in pgpass file it's still a plain text. How to hide it ?
- Original Message -
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>
Cc: "Zlatko Mati?" <[EMAIL PROTECTED]>; "Matthew T. O'Connor"
;
Sent: Wednesday, October 12, 2005 1:14 AM
Subjec
ok, thanks
- Original Message -
From: "A. Kretschmer" <[EMAIL PROTECTED]>
To:
Sent: Monday, September 05, 2005 6:15 PM
Subject: Re: [GENERAL] remote connection, web hosting, IP adress
am 05.09.2005, um 15:49:23 +0200 mailte Zlatko Mati? folgendes:
How can I connect to remote serve
Hello, Andreas!
You mentioned: "Use serial or serial4 to create auto-values. Don't use
any bigint-types like bigserial. Access doesn't like 8-byte-ints.".
Could you please explain why you don't recommend bigserial for primary key ?
I use bigserial primary keys in Postgres tables, and din'
Thanks for explaination.
Zlatko
- Original Message -
From: "Sean Davis" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: "pgsql list"
Sent: Sunday, July 24, 2005 1:27 AM
Subject: Re: [GENERAL] temporary tables ?
Wh
What is the influence on database growing in comparrison to permanent table
frequently inserted/deleted rows ?
- Original Message -
From: "Sean Davis" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: "pgsql list"
Sent: Friday, J
Hello.
I have some tables that are updated by several users in the same time and
are used in queries for reports. Those tables have rows that are actualy
copied from original tables that are not to be altered. There is a
procedure that inserts rows for every user when connects, along with his
Hello Ets!
I think that you should use Format, so
that Access can understands bools.
I have done it in this way:
In Access Query Builder use alias for field,
for example
AliasName:
Format([FieldName])
In Criteria use "True" or
"False" instead of -1
Tell me if it works for you. In my
thanks.
- Original Message -
From: "Matt Van Mater" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, June 30, 2005 7:25 PM
Subject: Re: [GENERAL] how to use pg_dump and then restored onto development
server
On 6
sible?
Thanks.
- Original Message -
From: "Douglas McNaught" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: "ketan shah" <[EMAIL PROTECTED]>;
Sent: Wednesday, June 29, 2005 5:29 PM
Subject: Re: [GENERAL] how to use pg_dump a
Concerning this question about pg_dump, I'm also
confused and don't understand when to use pg_restore and when to use psql
?
For example, how to restore in these two cases:
A) pg_dump -f D:\MYDB_BCP -c -x -h localhost -U
postgres MYDB
B) pg_dump -f D:\MYDB_BCP -Fc -c -x -h localhost -U
pos
Hi.
Yes, you were right. I added lines for template0 and template1 into
pgpass.conf file and now it works.
I'm wondering how to include timestamp in backup file name ?
- Original Message -
From: "Andreas" <[EMAIL PROTECTED]>
To: "Zlatko Matic"
Mike, you have:
pg_dump -f Name-Of-My-Dump-File -Fc -Z 9 -h localhost -U myUserName myDBname
How do you exactly restore it ? By pg_restore or psql ? What parameters ?
- Original Message -
From: "Relyea, Mike" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL
pts for password...What is wrong ?
- Original Message -
From: "Relyea, Mike" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>;
Sent: Tuesday, June 28, 2005 7:55 PM
Subject: RE: [GENERAL] automating backup ?
1) Create the directory %AP
I would appreciate some example.
Thanks.
- Original Message -
From: "Relyea, Mike" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>;
Sent: Tuesday, June 28, 2005 3:56 PM
Subject: Re: [GENERAL] automating backup ?
That's because they
Magnus Hagander" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>; "Andreas" <[EMAIL PROTECTED]>;
Sent: Tuesday, June 28, 2005 10:16 AM
Subject: Re: [GENERAL] automating backup ?
Hello.
I created a Windows XP schedule for backup, following your
LOBALS -U postgres -g
Well, it works OK, but prompts for password every time. Is there any way
that I pass the superuser password (off course, in safe way) so that it
works automatically without prompting for password ?
- Original Message -
From: "Andreas" <[EMAIL PROTECTED]>
thank you Andreas!
- Original Message -
From: "Andreas" <[EMAIL PROTECTED]>
To:
Cc: "Zlatko Matic" <[EMAIL PROTECTED]>
Sent: Monday, June 27, 2005 12:43 PM
Subject: Re: [GENERAL] automating backup ?
Zlatko Matic schrieb:
Thanks Fuhr.
Anybody can te
Thanks Fuhr.
Anybody can tell me how to do it on Windows XP ?
Thanks.
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
Sent: Sunday, June 26, 2005 2:59 PM
Subject: Re: [GENERAL] automating backup
How to automate backup, so that Postgres automatically backups, for example,
once in a week ?
The same question about vacuum ?
Concerning backup, how to prevent that someone makes a copy (for example
pg_dumpall) of a database, then installs new instance of Postgres, create
the same user acount
Ok.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Thursday, June 16, 2005 3:06 PM
Subject: Re: [GENERAL] pg_dumpall
On 16 Jun 2005 at 11:36, Zlatko Matic wrote:
Ok. but I have a problem. When i double-click, a black window appears,
p
Done. Thanks.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Thursday, June 16, 2005 3:06 PM
Subject: Re: [GENERAL] pg_dumpall
On 16 Jun 2005 at 11:36, Zlatko Matic wrote:
Ok. but I have a problem. When i double-click, a black wi
Hello.
I have experoenced the same problem. It seems to be
common problem with Access connectiong to ODBC data source. It seems that Access
has some problems to determine primary key...
You should not use textual fields as primary key.
Insted, add some bigserial (integer autoincrement field
Hi. Recently I have tried to do the same thing and I coudn't include
inheritence in existing tables. After a half of day of frustration, I have
got an idea. I have successfully done it by using EMS PostgreSQL Manager
Lite (you can download it from the net).
There is an option "Duplicate" in EM
Hello, Mike!
Your solution for audit trail is wonderfull! Easy and elegant !
It helped me a lot and I successfully implemented it, with small
modifications.
Thanky you very much!
- Original Message -
From: "Mike Rylander" <[EMAIL PROTECTED]>
To: "Zlatko Mat
Hello.
I must have audit trail of all insert/update/delete on several table. I have
several questions regarding that:
1. Is it better to have one audit trail table that collects
insert/update/delete of all audited tables, or it is better to have separate
audit trail table for every audited t
string of executive query.
' written by: Zlatko Matic
'
Sub QueriesAndParameters ()
Dim ws As DAO.Workspace
Dim db As DAO.DATABASE
Dim QueryName As String
Dim NumberOfParameters As Integer
On Error GoTo ErrorHandler
DoCmd.Hourglass T
Hello.
When building ODBC connection string for PostgreSQL there are constants
beginning with A, B and C. Where can I find description of each of these ?
Thanks.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
ot;
Case Else
MsgBox "An error occured in the function 'TransferQueryToTable': "
& Err.Number & " " & Err.Description
End Select
End Function
++
Just thought I'd share in case it
I was using ADO command object and both refresh method and method with
creating parameter object while working with Access Project...but I didn't
try to use it with PostgreSQL...
I would rather like to have all queries on client side anyway. Therefore I
use pass-through queries. But it doesn't a
Hello...This is very interesting. I have also asked myself how to prepare
and execute stored procedures on POstgre from MS Access.
Could you, please, give some example of Postgre function with parameters
that is executed as stored procedure from MS Access? How would you pass
parameters ? Using A
I have installed lazarus. A have also downloaded zeos library, but don't
know how to install it. What am I suppsoed to do?
Thanks.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
What about Lazarus Has anybody tried working with Lazarus?
- Original Message -
From: "Daniel Schuchardt" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, May 10, 2005 2:27 PM
Subject: [GENERAL] Delphi - Developers start develop Access components for
Postgres?
Hy,
in thread "Adventures in Quest
Can someone explain me the following options while using pgAdimn III for
backup:
blobs
insert commands
verbose messages
Thanks.
- Original Message -
From: "Sean Davis" <[EMAIL PROTECTED]>
To: "Hrishikesh Deshmukh" <[EMAIL PROTECTED]>; "Ben"
<[EMAIL PROTECTED]>
Cc: "Postgresql-General"
thanks.
- Original Message -
From: "Michael Glaesemann" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 09, 2005 11:30 AM
Subject: Re: [GENERAL] = or := ?
On May 9, 2005, at 18:00, Zlatko Matic wrote:
This is a newbie
Hello.
This is a newbie question: what is the difference between using = and := in
plpgsql function ?
I tried with both and in both cases my function works...
Thanks.
Zlatko
---(end of broadcast)---
TIP 2: you can get off all lists at once with th
Hello.
It seems that many people fanatically recommend Delphi, while others
fanaticaly despise Delphi. I've sent a question about comparative features
of MS Access/Visual Studio/Delphi for working with databases to a newsgroup
and people started to quarell instead of argumenting anything !
Inte
al Message -
From: "Jeff Eckermann" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>;
; <[EMAIL PROTECTED]>
Sent: Wednesday, May 04, 2005 6:01 PM
Subject: Re: [GENERAL] [INTERFACES] calculated identity field in views,
again...
--- Zlatko Matic <[EMA
create sequence ?
- Original Message -
From: "Greg Stark" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>
Sent: Wednesday, May 04, 2005 7:11 AM
Subject: Re: [GENERAL] [INTERFACES] calculated identity field in vie
You mean VB.NET ?
- Original Message -
From: "Keith Worthington" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>
Sent: Wednesday, May 04, 2005 5:58 AM
Subject: Re: [INTERFACES] calculated identity field in views,
I asked this question several weeks ago, but nobody proposed a solution, so
I am repeating the same question again...
I have an MS Access front-end for a database on PostgreSQL.
I could use pass-through queries as record sources for reports and it works
fine...
Unfortunately, MS Access doesn't al
Hello,
I am currently migrating my MSDE/Access (Access Project) aplication to
PostgreSQL.
I have experienced a lot of obstacles till now, but anyway it seems quite
posible to make a good aplication by this combination of Access front-end and
PostgreSQL base.
I use the following ODBC setting
I know that it sounds crazy,
but I need a bigserial coulumn in a view that is consisted of several
tables.
That column should not be based on bigserial column of any table, but
should be a calculated column...
How can I accomplish it ?
Thanks in advance.
Zlatko
ssage -
From: "Richard Huxton"
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, April 21, 2005 5:06 PM
Subject: Re: [GENERAL] bigserial field in a view, nextval function ?
Zlatko Matic wrote:
I need to have an "identity" column in a view.
I
I need to have an "identity" column in a view.
I was using bigserial columns in tables and Postgre created nextval function
expression automatically.
Now I have tried with nextval function in the view, but with no success
How can I put a bigserial column in a view ?
Thanks.
58 matches
Mail list logo
