search for: datname

...; Export<http://124.43.200.74/phpPgAdmin/all_db.php?subject=server&action=export&server=%3A5432> Reports<http://124.43.200.74/phpPgAdmin/reports.php?subject=server&server=%3A5432> *SQL error:* ERROR: relation "pg_user" does not exist *In statement:* SELECT pdb.datname AS datname, pu.usename AS datowner, pg_encoding_to_char(encoding) AS datencoding, (SELECT description FROM pg_description pd WHERE pdb.oid=pd.objoid) AS datcomment FROM pg_database pdb, pg_user pu WHERE pdb.datdba = pu.usesysid AND NOT p...

Hello, I have configured puppet and puppetdb (storeconfig) with postgresql and the service run and the collecting are good for example: I can make query with the next command and responds ok . [.........................] [root@master]# curl -X GET -H ''Accept: application/json'' http://127.0.0.1:8080/v2/facts --data-urlencode ''query=["=", "name",

Estimados usurios-R: Tengo una lista de alumnos. Hay alguna forma de sacar una tabla de frecuencias por la asistencia a clases mensual. Es decir cuantos días concurrió cada alumno en el mes. Supongamos que la lista está conformada por ocho alumnos, el curso duró 4 días y quiero saber cuantos días concurrió cada uno al curso poniendolo en la columna mes. Quisiera obtener un cuadro así: Alumnos

Just wondering if it's possible to have an item with no content at all. Here's what I was hoping to do, inside a larger function that acts on a 3-D array. I want to enter, as one of the arguments to the main function, the index over which I'm going to do some action. For example, if the action were to calc a sum, I'd specify a given axis and report the sums along that axis

Say I have a file called exp.batch which contains 2 cols The first col contains names of R objects the user would like to use. The second col contains the file names which will be read in using read.table i.e. exp.batch may look like this..... name1 complex/filename/path1.txt name2 complex/filename/path2.txt name3 complex/filename/path3.txt name4 complex/filename/path4.txt I want to have a

...; database.out pg_dump: SQL command failed pg_dump: Error message from server: ERROR: relation "pg_user" does not exist pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding, datpath FROM pg_database WHERE datname = 'database' Thank you for your help! Andy

...QL command failed > pg_dump: Error message from server: ERROR: relation "pg_user" does not > exist > pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE > usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding, > datpath FROM pg_database WHERE datname = 'database' Googling for the error message (*hint hint*) indicates this is most often caused by a version mismatch between your pg_dump, psql, etc, and the actual postgres database you are connecting to. Is that the case? -- Marc