The csv has 34 columns and I need to create a crosstab (using 8 columns so
I can't use built in crosstab functions). That is why I need to make
several sql select.
I'm using foreign table so my client can update is csv file without having
to run the ETL to update a table in postgres.
Using tem
Hi,
Using postgres 9.2, I created a FOREIGN TABLE on a csv file. It works.
But I need to change the structure of the data and I created several sql
select using union, like
select from .foreign table... where...
union
select from .foreign table... where...
union
...
It works for the firs
Thanks Kevin,
Which of these 2 methods is the best practice?
It is working with pgpass.
But not yet with hba.conf
I tried this without success.
hostall all 127.0.0.1/32 trust
steve
"Kevin Grittner"
27/07/2010 01:17 PM
A
,
cc
Objet
Re: [ADMIN] psql shell with
Hi,
I created several SQL that are automatically executed via windows task
scheduler, here is an example
psql -U "dbadmin" -d mydb -f D:\script.sql
It was running well until I changed the user (to open a session)
associated to these task.
The script prompt for a password for user dbadmin.
How to
