Is there a pl/pgsql equivalent to this Oracle command?
DBMS_OUTPUT.PUT.LINE('This outputs to display when this line runs');
?
-g
How should I take backup in PostGreSQL(should be a sql dump)? is there any backup command like "mysqldump" which we have in mysql.
i am trying to get the output from a SELECT command to be comma separated and each field has to have quotes around it. I need to do that in psql. I have tried this but it doesn't work:
>psq...
1)I saw a comment from experts-exchage regarding shared_buffers, where max_connections were 600
2000 shared buffers were for 40 connections
For 600 connections it looks more like 30000 sha...
Give me some insights which can be compared with INGRES ?
How do you transfer a table from one postgres db to another in Postgres 7.2.3-5.75.
I'm looking for a tool for database comparison and synchronization for PostgreSQL.
Basically what I wanted to do is automate the task of checking the latest alterations/modifications in the S...
Hello,
I am working on a libpqxx project within visual studio. Having connected to a database, is there some function or method I can call that will :
A. Return the current database pass...
I am using the postgresql 8.2.4 in windows.When I don't have enough space left on my harddisk, postgresql is logging the message "could not write to log file: No space left on device" to Windo...
I am looking for a simple PostgreSQL query to show which rows that have fields in one table that are not found in another table.
select * from
(
select fieldA from schema1.table1
union ...
I have a DB is PostgreSQL 8.2 running on UltraSparc T2 Processor ( SUN T5120). All applications connecting to this DB will be using Store Porcedures. We have SPs for INSERT, DELETE, SELECT ,et...
Hi expert,
I'm newbie to postgresql, I'm trying to migrating from MS-SQL to Postgresql.But I stuck at uniqueidentifier datatypes which is not available to postgresql. Can anyone suggest m...
hy,
I have a postgres database and my aim is to save a JPG file from disk for exemple (d:/file.jpg)
to a postgres database (bytea column)
First i want to create a CbyteArray of this image...
i want to connect to postresplus database thru' perl
im using DBD::pgpp driver.
i received an error message "couldnt coonect to /tmp/.s.PGSQL.5432"
In readme i notice that i need to cha...
I would like to connect to a postgresql-server using PGAdmin instead of phpPgAdmin. It is not so difficult to open a port, and limit the connection to my own ip-address. Is it possible to requ...
Hi,
I am trying to install the Windows version of Postgresql (v8.4.1) onto a Windows Server 2003 machine that acts as our domain controller.
The issue starts when I have to create the p...
Hi!
I´m looking for any document or page that can show me statistics on this matter. I need to know what benefits can PostGre offer, and how do these compare to the ones Oracle offer. ...
How would I turn this query:
select c.client_id, c.firstname, c.surname, c.bus_phone, c.fax, c.home_phone, c.mobile, c.email_addr,
o.customer_followup from
client_customer c, ( select c...
In Netezza database i have table called TableA. This table has many vendor details. Now i need to create .CSV file for each vendor details in the particular folder. File name like "VendorNo_YY...
I'm Windows desktop application developer and have been working on client/server application with Postgresql as database. I would like to implement SSL connection with my application.
I rea...
what is the disadvantages ?
I've written a PL/PgSQL boolean function that inserts a new product into my database. My intention is to call this function from within my C++ frontend, and have it return false if it doesn't ...
We are using PostgreSQL 8.2 on Linux.
We have a cron job which executes, once a day, actually at night, ANALYZE and VACUUM FULL to the database. Autovacuum option is disabled and we also have...
What would cause an error such as "ERROR: cache lookup failed for relation #######"? This happens from time to time (a lot lately) and occurs when trying to insert data from a CSV file. I c...
I need to create a long text field using hibernate with postgres.
I used this statement in my .hbm.xml
<property name="hyperlink" type="string" length="2000" >
<column name="HYPERL...
