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