general questions

CS DBA <cs_dba@consistentstate.com> writes:

1) \d and schema's
- I setup 2 schema's (sch_a and sch_b)
- I added both schema's to my search_path
- I created 2 tables: sch_a.test_tab and sch_b.test_tab

If I do a \d with no parameters I only see the first test_tab table
based on the order of my search_path.
I get that any queries will use the first found table if I don't specify
the schemaname but
if I'm looking for a full list (i.e. \d with no parameters) I would
think I should get a full list back

Is this intentional?

Yes. If you want to see stuff that's invisible in your current search
path, use "\d *.*". That's even documented somewhere ...

2) SET work_mem = x
It seems that any user can run set work_mem = x in a session.

Yup. If a user can issue arbitrary SQL, they can drive your server into
the ground with or without that, so I see little point in restricting it.
(Indeed, restricting it could be counterproductive, since too *small*
a value can be just as bad for performance as too large.)

3) Can I force unaligned mode AND no wrap for psql output?

[ shrug ... ] Dunno, read the manual.

4) Is there a way to know for sure ifa sql file was run in single
transaction mode (after the fact), i.e. something in the logs?

If you're logging individual statements, there will be BEGIN and
COMMIT logged. If you're not, I doubt the log will even tell you
a sql file was run, let alone such details.

5) Is there a query that will show me the actual prepared SQL text for a
prepared query?

select * from pg_prepared_statements

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Thu, Jan 9, 2014 at 5:04 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

CS DBA <cs_dba@consistentstate.com> writes:

1) \d and schema's
- I setup 2 schema's (sch_a and sch_b)
- I added both schema's to my search_path
- I created 2 tables: sch_a.test_tab and sch_b.test_tab

If I do a \d with no parameters I only see the first test_tab table
based on the order of my search_path.
I get that any queries will use the first found table if I don't specify
the schemaname but
if I'm looking for a full list (i.e. \d with no parameters) I would
think I should get a full list back

Is this intentional?

Yes. If you want to see stuff that's invisible in your current search
path, use "\d *.*". That's even documented somewhere ...

As Tom already said, am adding document pointer, you can find i
n "patterns"
.

http://www.postgresql.org/docs/9.3/static/app-psql.html

3) Can I force unaligned mode AND no wrap for psql output?

For both unaligned
AND
no wrap, I guess you need to take help of PAGER and
"
psql
-A
" or "
p
ostgres=#
\a
"
or
"postgres=#
\pset format unaligned
"

I would try like:

export PAGER='less -RSX' // It no wraps the output
psql -A

// Unaligned

--
Raghav

EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/