PostgreSQL 12 - psql - csv output
After some years and long discussion, a
psql console has great feature - Usage is very simple, just use
--csv option.[pavel@nemesis postgresql.master]$ psql --csv -c "select * from pg_namespace limit 10" postgres
oid,nspname,nspowner,nspacl
99,pg_toast,10,
10295,pg_temp_1,10,
10296,pg_toast_temp_1,10,
11,pg_catalog,10,"{postgres=UC/postgres,=U/postgres}"
2200,public,10,"{postgres=UC/postgres,=UC/postgres}"
11575,information_schema,10,"{postgres=UC/postgres,=U/postgres}"

0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home