URL: <https://savannah.gnu.org/patch/?10535>
Summary: Add support for either TYPE=ODBC or TYPE=PSQL in
windows 10
Group: PSPP
Submitter: rogerjdeangelis
Submitted: Thu 24 Jul 2025 03:18:53 PM GMT
Category: None
Item Group: None
Status: None
Assigned to: None
Originator Email:
Open/Closed: Open
Discussion Lock: Any
_______________________________________________________
Follow-up Comments:
-------------------------------------------------------
Date: Thu 24 Jul 2025 03:18:53 PM GMT By: roger <rogerjdeangelis>
Works well with csv but not psql or odbc on windows. I tried to compile with
missing libraries but it failed.
There seems to be an issue reading from an existing postgres database.
TIA Roger
[email protected]
GET DATA
/TYPE=PSQL
/CONNECT='host=localhost dbname=postgres user=postgres'
/SQL='SELECT * FROM have';
error: Support for reading postgres databases was not compiled into this
installation of PSPP
This works
DATA LIST FIXED / qry 1-80 (A).
BEGIN DATA
drop table if exists sqlhav;
drop table if exists want;
\dt
create
table sqlhav
(NAME TEXT,SEX TEXT,AGE REAL,WEIGHT REAL);
\copy sqlhav from 'd:/csv/have.csv' delimiter ',' csv header;
\dt
create
table want as
select
sex
,avg(age) as avgage
,avg(weight) as avgwgt
from
sqlhav
group
by sex
;
\dt
\copy want TO 'd:/csv/wantout.csv' CSV HEADER;
END DATA.
LIST.
SAVE TRANSLATE
/OUTFILE='c:/temp/output.sql'
/TYPE=TAB
/REPLACE.
HOST COMMAND=['psql -U postgres -d template1 -f c:/temp/output.sql'].
GET DATA
/TYPE=TXT
/FILE='d:/csv/wantout.csv'
/DELCASE=LINE
/DELIMITERS=","
/QUALIFIER='"'
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/VARIABLES=SEX A1 AVEAGE F8.2 AVGWGT F8.2.
EXECUTE.
SAVE OUTFILE='d:/sav/want.sav'.
LIST.
_______________________________________________________
Reply to this item at:
<https://savannah.gnu.org/patch/?10535>
_______________________________________________
Message sent via Savannah
https://savannah.gnu.org/
signature.asc
Description: PGP signature
