Login or Register to Ask a Question and Join Our Community


OS X OpenSource RSS

PostgreSQL 9.0

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems OS X (Apple) OS X OpenSource RSS PostgreSQL 9.0
# 1  
Old 09-25-2010
CPU & Memory PostgreSQL 9.0
ImageAbout PostgreSQL
One of the leading Open Source database engines available today. With features more competitive to the top tier commercial vendors than other Open Source alternatives, the platform offers a wide range of features and abilities. Adding to that value is a more Mac friendly packaging that eschews the need to be a developer or experienced Unix system administrator to set up.

Run the installer, start and stop the server from System Preferences and use graphical tools to create users, databases and run queries. For automation purposes, there are Automator actions included in the package, along with JDBC libraries, and a ready to use framework that enables Cocoa developers to quickly access and consume PostgreSQL data.

More from Apple...
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Setting up postgreSql database

Hi I have a small bash script which I want to run on an Amazon EC2 Ubuntu instance for setting up a postgreSQL database: #!/bin/bash USERNAME='postgres' start=$SECONDS TMP_DIR=/local/test/4g4d PORT=23456 rm -rf $TMP_DIR/db mkdir -p $TMP_DIR/ echo "creating database..."... (3 Replies)
Discussion started by: Helveticus
3 Replies

2. 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

3. UNIX and Linux Applications

PostgreSQL vacuum in cron

I'm running vacuum for PostgreSQL with a script in cronjob. How to check if there were errors? thanks. (6 Replies)
Discussion started by: orange47
6 Replies

4. Solaris

Determining PostgreSQL version

I need to find out if a version of PostgreSQL installed in SPARC Solaris is > 7.2 please tell me how to do it. thanks. (4 Replies)
Discussion started by: orange47
4 Replies

5. 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

6. 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

7. Programming

SQL Functions - PostgreSQL

Hi guys. I have some questions about SQL functions in postgresql: 1. Can a SQL function call another SQL function? 2. How about recursive calls? 3. Consider we have function that has a varchar argument. CREATE FUNCTION func(varchar) RETURN void AS $$ some SQL queries. ... (0 Replies)
Discussion started by: majid.merkava
0 Replies

8. 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
Login or Register to Ask a Question

LEARN ABOUT PHP

pg_escape_string

PG_ESCAPE_STRING(3)													       PG_ESCAPE_STRING(3)

pg_escape_string - Escape a string for query

SYNOPSIS

       string pg_escape_string ([resource  $connection], string  $data)

DESCRIPTION

       pg_escape_string(3)  escapes  a	string	for  querying  the database. It returns an escaped string in the PostgreSQL format without quotes.
       pg_escape_literal(3) is more preferred way to escape SQL parameters for PostgreSQL. addslashes(3) must not be used with PostgreSQL. If  the
       type  of the column is bytea, pg_escape_bytea(3) must be used instead. pg_escape_identifier(3) must be used to escape identifiers (e.g. ta-
       ble names, field names)

       Note

	       This function requires PostgreSQL 7.2 or later.

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).

	      o $data
		- A string containing text to be escaped.

RETURN VALUES

	A string containing the escaped data.

CHANGELOG

       +--------+-------------------+
       |Version |		    |
       |	|		    |
       |	|    Description    |
       |	|		    |
       +--------+-------------------+
       | 5.2.0	|		    |
       |	|		    |
       |	| $connection added |
       |	|		    |
       +--------+-------------------+
EXAMPLES

       Example #1

	      pg_escape_string(3) example

	      <?php
		// Connect to the database
		$dbconn = pg_connect('dbname=foo');

		// Read in a text file (containing apostrophes and backslashes)
		$data = file_get_contents('letter.txt');

		// Escape the text data
		$escaped = pg_escape_string($data);

		// Insert it into the database
		pg_query("INSERT INTO correspondence (name, data) VALUES ('My letter', '{$escaped}')");
	      ?>

SEE ALSO

       pg_escape_bytea(3).

PHP Documentation Group 												       PG_ESCAPE_STRING(3)