Reputation
8,719
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 20 46
Newest
 Caucus
Impact
~425k people reached

Jul
14
comment How to deal with large amounts of data - PHP
Or, if you were on PostgreSQL, you could store it in an array in the database. Please note that one does not build an application using phpmyadmin - it is a client tool for MySQL.
Jul
14
comment A complex query to Joining 2 tables and getting result
@RickJames why do you expect the two being any different?
Jul
14
comment Multiple table relationship for different scenarios!
Please show your ERD - it describes the situation the best.
Jul
14
comment MySQL : How to restore mysql dump (.sql) ignoring DROP TABLE statement?
What about the CREATE TABLE statements? Furthermore, grep -v ... 1.sql does just the same, no need for cat.
Jul
13
comment How to use variables in a PL/pgSQL function with dynamic queries?
What is object_id()? And tempdb? Also, quote_ident() is necessary only for database object names, it would throw an error if applied to column values. The second example with the INSERT does not need a dynamic query at all. BTW, which PostgreSQL version do you use?
Jul
13
comment Building a restaurant database
What is ISA? And what do you mean by 'readable'?
Jul
13
comment Does reporting webservice url contain the function that helps to export the report to the client version?
In broader: please include here the steps/elements of the solution that helps the OP. You might have the idea later to move your page to somewhere else - in this case the link will 'rot', making this answer useless.
Jul
13
comment pgbouncer cannot connect to multi-homed server
OK. Then please show the IPs the name resolves to, and the commands that succeed/fail.
Jul
13
comment Oracle Performance on 2 servers
If I see it correctly, the timing involves transporting data over to the client. Can it be that this is the only source of the time difference?
Jul
13
comment pgbouncer cannot connect to multi-homed server
So you mean that the round robin is set up correctly (giving back the two IPs in a permuted order every time), but one of them does not accept connections, got it. In this case, is this on purpose, or simply no DB is running there?
Jul
13
comment pgbouncer cannot connect to multi-homed server
I'm voting to close this question as off-topic because this is a system administration problem, therefore it belongs possibly to suerpuser.stackexchange.com
Jul
13
comment How to prevent multiple queries in this case?
As an aside, it's not a very wise idea to name tables with keywords.
Jul
10
comment SQL Join Field and Content
Could you then remove the references to HTML? And possibly add an example output table.
Jul
10
comment SQL Join Field and Content
Are you sure a SQL join will produce HTML for you?
Jul
10
comment Why postgresql pg_dump exports a view as a table?
Is it a materialized view?
Jul
10
comment GRANT USAGE on all schemas in a database? postgres
@a_horse_with_no_name thinking about it, I see currently no reason why it could not be done.
Jul
10
comment Implementing a function written for Postgres 9.4 in Postgres 8.4
According to postgresql.org/docs/8.4/static/sql-createtable.html, the IF NOT EXISTS syntax didn't exist in 8.4 (appeared in 9.1)
Jul
10
comment Implementing a function written for Postgres 9.4 in Postgres 8.4
Just out of curiosity, why cannot you upgrade?
Jul
10
comment Implementing a function written for Postgres 9.4 in Postgres 8.4
Well, the format( is missing from your post - otherwise, you have to concatenate and quote with quote_ident(). But the best suggestion would be upgrading ;)
Jul
10
comment Where is the default postgres user path environment set?
I'm voting to close this question as off-topic because it's a sysadmin problem, thus a topic for SU