Sponsored Content
Operating Systems Solaris Determining PostgreSQL version Post 302543037 by orange47 on Friday 29th of July 2011 08:39:11 AM
Old 07-29-2011
Quote:
Originally Posted by DukeNuke2
there is no solaris 7.2... but to check installed packages use "pkginfo".
no, I need to know if Postgre is >7.2

pkginfo doesn't help. it seems this is some 'custom built' postgre and pkginfo reports:
VERSION: release 5.10
but that seems like solaris version or something.

I need to be sure postgre version is above 7.2

edit:
I found this:
" How do I tell what PostgreSQL version I am running?
Run this query: SELECT version(); "

but don't know how to run query..

Last edited by orange47; 07-29-2011 at 10:00 AM..
 

7 More Discussions You Might Find Interesting

1. SuSE

postgresql-jdbc on Suse

Hi, I am writing a Java Swing application and want to add Embedded SQL to it. The application should interact with a PostgreSQL database running on my local machine. The compiler complains that it cannot find the org.postgresql package included in the code. I'm guessing the problem is that... (0 Replies)
Discussion started by: marina
0 Replies

2. UNIX and Linux Applications

Perl - PostGreSql query

Guys, I guess, I posted something in the wrong forum. Here it is - https://www.unix.com/shell-programming-scripting/67395-perl-postgrepsql-question.html Can you please help me with this? Regards, garric (0 Replies)
Discussion started by: garric
0 Replies

3. Programming

kill - postgresql

Hi guys. I was was designing a simple database in postgresql. I wrote a perl function in postgresql and execute it. suddenly i saw that it is running in an infinite loop. After i stopped executing of the query, i saw that CPU is in 90%+ load. I looked at process list and there it was. postgresql... (1 Reply)
Discussion started by: majid.merkava
1 Replies

4. UNIX for Dummies Questions & Answers

PostgreSQL - can not find server

I am first year year student .. and i need help i tried to work with PostgreSQL but when i open the terminal, i face problem in how to reach to PostgreSQL . always i get message it says that " can not find server " . so what shall i do please .....:( (9 Replies)
Discussion started by: barlom
9 Replies

5. UNIX and Linux Applications

PostgreSQL problem with vacuumdb

I am trying to run vacuumdb script. but it exits with an error: "ld.so.1: vacuumdb:fatal libpq.so.5 open failed no such file or directory" same error is with some other pstgre commands. please, help. thanks. edit: it seems I need to set LD_LIBRARY_PATH properly. but how to add to it?... (0 Replies)
Discussion started by: orange47
0 Replies

6. Solaris

Postgresql installation

Hi all, I want to install two postgreql 8.3.5 instances on same servers. already one instalce is running on default port and i need it to be installed on another port.. How ever i achived installing the second instance.. but the problem is if i create a new user using createuser in the newly... (3 Replies)
Discussion started by: phani4u
3 Replies

7. Shell Programming and Scripting

Copy a file from directroy/ prior version to the directory/ new version

How to copy a file from directroy/ prior version to the directory/ new version automatically. (4 Replies)
Discussion started by: roy1912
4 Replies
PG_CLIENT_ENCODING(3)													     PG_CLIENT_ENCODING(3)

pg_client_encoding - Gets the client encoding

SYNOPSIS
string pg_client_encoding ([resource $connection]) DESCRIPTION
PostgreSQL supports automatic character set conversion between server and client for certain character sets. pg_client_encoding(3) returns the client encoding as a string. The returned string will be one of the standard PostgreSQL encoding identifiers. Note This function requires PHP 4.0.3 or higher and PostgreSQL 7.0 or higher. If libpq is compiled without multibyte encoding support, pg_client_encoding(3) always returns SQL_ASCII. Supported encoding depends on PostgreSQL version. Refer to the PostgreSQL Documenta- tion supported encodings. The function used to be called pg_clientencoding(3). PARAMETERS
o $connection - PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection is the last connection made by pg_connect(3) or pg_pconnect(3). RETURN VALUES
The client encoding, or FALSE on error. EXAMPLES
Example #1 pg_client_encoding(3) example <?php // Assume $conn is a connection to a ISO-8859-1 database $encoding = pg_client_encoding($conn); echo "Client encoding is: ", $encoding, " "; ?> The above example will output: Client encoding is: ISO-8859-1 SEE ALSO
pg_set_client_encoding(3). PHP Documentation Group PG_CLIENT_ENCODING(3)
All times are GMT -4. The time now is 05:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy