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
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
: 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
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
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
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.
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
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
unsubscribe
Have you tried to restore just schema first, then data?
Greetings,
Zlatko
- Original Message -
From: Howard Cole [EMAIL PROTECTED]
To: 'PgSql General' pgsql-general@postgresql.org
Sent: Friday, December 02, 2005 3:02 PM
Subject: [GENERAL] Unicode Corruption and upgrading to 8.0.4. to
what is the schedule for releasing first official 8.1 ?
- Original Message -
From: Magnus Hagander [EMAIL PROTECTED]
To: Marc G. Fournier [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Monday, October 24, 2005 8:04 PM
Subject: Re: [GENERAL] [ANNOUNCE] PostgreSQL 8.1 Beta 4
thanks for information
- Original Message -
From: Matthew T. O'Connor matthew@zeut.net
To: Zlatko Matic [EMAIL PROTECTED]
Cc: Magnus Hagander [EMAIL PROTECTED]; Marc G. Fournier
[EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Tuesday, October 25, 2005 2:40 PM
Subject: Re
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: Tom Lane [EMAIL PROTECTED]; Matthew T. O'Connor
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
matthew@zeut.net; pgsql-general@postgresql.org
Sent: Wednesday,
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
matthew@zeut.net; pgsql-general@postgresql.org
Sent: Wednesday, October 12, 2005 1:14 AM
Subject: Re: [GENERAL] user
ok, thanks
- Original Message -
From: A. Kretschmer [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
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
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't
Thanks for explaination.
Zlatko
- Original Message -
From: Sean Davis [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED]
Cc: pgsql list pgsql-general@postgresql.org
Sent: Sunday, July 24, 2005 1:27 AM
Subject: Re: [GENERAL] temporary tables ?
What is the influence on database
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 pgsql-general@postgresql.org
Sent: Friday, July 22, 2005 8:06 PM
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
thatAccess can understands bools.
I have done it in this way:
In AccessQuery 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 case it
thanks.
- Original Message -
From: Matt Van Mater [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, June 30, 2005 7:25 PM
Subject: Re: [GENERAL] how to use pg_dump and then restored onto development
server
On 6/29/05, Douglas
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 [EMAIL PROTECTED]
Cc: pgsql-general
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 PROTECTED];
pgsql-general
Concerning this question about pg_dump, I'm also
confusedand 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
?
Thanks.
- Original Message -
From: Douglas McNaught [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED]
Cc: ketan shah [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Wednesday, June 29, 2005 5:29 PM
Subject: Re: [GENERAL] how to use pg_dump and then restored onto development
[EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED]; Andreas [EMAIL PROTECTED];
pgsql-general@postgresql.org
Sent: Tuesday, June 28, 2005 10:16 AM
Subject: Re: [GENERAL] automating backup ?
Hello.
I created a Windows XP schedule for backup, following your
instruction. Now I have a .bat file
I would appreciate some example.
Thanks.
- Original Message -
From: Relyea, Mike [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED];
pgsql-general@postgresql.org
Sent: Tuesday, June 28, 2005 3:56 PM
Subject: Re: [GENERAL] automating backup ?
That's because they don't exist. You
for password...What is wrong ?
- Original Message -
From: Relyea, Mike [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED];
pgsql-general@postgresql.org
Sent: Tuesday, June 28, 2005 7:55 PM
Subject: RE: [GENERAL] automating backup ?
1) Create the directory %APPDATA%\postgresql
in my
thank you Andreas!
- Original Message -
From: Andreas [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
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 tell me how
@postgresql.org
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 tell me how to do it on Windows XP ?
Thanks.
That's again a pure Windows issue, but not commonly needed.
I guess, it should
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
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: pgsql-general@postgresql.org
Sent: Sunday, June 26, 2005 2:59 PM
Subject: Re: [GENERAL] automating backup ?
On Sun
Ok.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; pgsql-general@postgresql.org
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
Done. Thanks.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; pgsql-general@postgresql.org
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
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
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 EMS
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 Matic [EMAIL PROTECTED]
Cc
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
.
' 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 True
Set ws = DBEngine(0)
Set
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Philippe Lang
Sent: Friday, May 13, 2005 3:10 AM
To: Zlatko Matic; pgsql-general@postgresql.org
Subject: Re: [GENERAL] MS-Access and Stored procedures
Hi,
You can use pass-through queries with parameters. You have to edit the
pass-through querydef
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?
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
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
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: pgsql-general@postgresql.org
Sent: Tuesday, May 10, 2005 2:27 PM
Subject: [GENERAL] Delphi - Developers start develop Access components for
Postgres?
Hy,
in
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
thanks.
- Original Message -
From: Michael Glaesemann [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
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 question: what
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
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 !
You mean VB.NET ?
- Original Message -
From: Keith Worthington [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 5:58 AM
Subject: Re: [INTERFACES] calculated identity field in views, again...
Zlatko
create sequence ?
- Original Message -
From: Greg Stark [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 7:11 AM
Subject: Re: [GENERAL] [INTERFACES] calculated identity field in views,
again...
Zlatko
: Jeff Eckermann [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED];
pgsql-general@postgresql.org; [EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 6:01 PM
Subject: Re: [GENERAL] [INTERFACES] calculated identity field in views,
again...
--- Zlatko Matic [EMAIL PROTECTED] wrote:
I asked
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
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
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
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.
-
From: Richard Huxton dev@archonet.com
To: Zlatko Matic [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
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 was using
58 matches
Mail list logo