PostgreSQL Database Forum

pg_dump remove name of schema from default value. i don't know why. how can i solve this problem ? For example: BEFORE PG_DUMP: CREATE TABLE "is8"."tb_kotuce" ( "id_kotuc" CHAR(10) DEFAULT is8.fn_sq_id_kotuc() NOT NULL, ... ...

I'm new to psql and I am trying to figure out how to find all the songs found in a particular month..any month. I have not one clue how to do this, nor have I found any meaningful examples. I'm hoping someone could at least start me off. I've built my schema as follows: Customer(customerID, customerName, customerPasswd, customerEmail)...

I seem to be having issues with the <psql -U postgres -d database1> -c "COPY <tablename> TO STDOUT;" | <psql -U postgres -d database2> -e -c "COPY <tablename> FROM STDIN;" when both databases reside on the same localhost machine. These commands work beautifully when the databases reside on different remote machines. I could find nothing in...

Hi! To you all again. With your help I've succeeded in placing an advanced constraint for entering data in the acct_dept_table (see advanced constraint). I would like to add more constraint in field entries in the dept_table I want to make sure that all the 5 characters in the dept table must be entered and that those 5 characters have to...

Hi! ALL I'm an novice programmer. Been trying to set up a database for an accounting program. What I want to do is have one table that contains the department number and name and another table that contains the account number and name. However I want the last 5 digits of the account number to refer to the department number that would be in the...

Hello I have some problem with psqldump. I need to read some table from my postgresql backup (psqldump file). is there any body can help me, how can i read this psqldump, or is there any way to transfer this file to text file or something so i can read the content of this file. can any body show me which command should i use ?, if there is an...

Hi, We need to compare the open souce Databases- MySQL and PostgerSQL based on features as well as on performance. If anyone has done such a comparison, please share your knowledge with us. Thanks, Yogesh

Hi, Can any one tell me how to find "duplicate values exists in columns or table". please reply as early as possible. ThanQ

Hi All, I have developed a web application using JBoss and POstgreSql.The application shouls work both in windows as well as in Linux. There is an option of taking database backup and restore database with a previously taken backup file from the browser. In order to restore I have generated a bat/sh file to start the process. In the bat/sh...

Hi all: Where can I find detailed information about pl/python? Thanks very much!

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 = 'dbname' Can anybody suggest to take the backup??

Hi, Pls guide me in synchronizing data from PostGre to Cache. i.e if we update in one database the other database must automatically get updated.I dont want to use the Tool ,I need the code for it 2 update from Postgre or from cache.

Dear all PostgreSQL xperts! Hi, I am newbie in PostgreSQL. I am currently developing an app that use PostgreSQL as a BackEnd Database. Now I am having problem with the function trigger since last week. Here's the case: create table nr_tr (tr_type character(3), period character(6), nr_tr integer); create table h_trsale(nr_tr integer,...

Hi how can I pass a user defined type or array of user defined type to a function? type: CREATE TYPE CARDDATARECTYPE AS (DATANAME VARCHAR(256), DATAVALUE VARCHAR(2048), ISDELETABLE SMALLINT ) By oracle jdbc I do this by following: StructDescriptor cardStruct = StructDescriptor.createDescriptor("CARDDATARECTYPE",stmt.getConnection());

Dear All, I have two postgreSQL server one is windows another one is linux.My clients making data entry in windows server this all the data want to replicat in linux postgreSQL server every hour.How i can do this concept in postgreSQL.Pls advice me.Advance thanks to all. Kindly Regards Siva

hi, i want to know how can i transfer the datas from oracle to postgre by using odbc. thanks

hi, i want to know how to transfer data from postgre to oracle,using odbc connection . thanks

Could anyone please tell me if it is possible to use prepared statement in postgresql for IN function? if its possible then hows it done? What I want to have would look something like this, prepare my_query as select something from sometable where some_column IN ($1); execute my_query('lookup_value','lookup_value','lookup_value') Please...

Is there a better way to write the statement below with postgre. It works fine, wondering if there might be a way with with only 1 extract. I just need only results returned if they fall on a 10 minute interval. Thanks. SELECT * FROM t1 WHERE EXTRACT(minute FROM timestamp) = 0 OR EXTRACT(minute FROM timestamp) = 10 OR ...

How to enable i18n in Postgresql database? I changed the executing environment to a Portuguese locale, and initdb to create a database cluster in the Portuguese locale. The command prompt showed 'invalid locale name pt_PT' but still created the cluster in the Portuguese locale. The problem is how to check if the pgAdmin is now in new...

Hi Friends I am having trouble with a function Round.This function returns different values in different scenarios. This is what happens when value was directly passed Query goes as follows * Passing Value directly zint numeric(12,0);

hi, i started the postgresql client the first time and wanted to execute commands from file and got the following error code: \i x:\file.sql x:: Permission denied i have admin rights, so why? WinVista Business PostgreSQL Version 8.2.6

Dear Friends, I guess the problem I am prosting right now should be quite trivial, but nevertheless I'm experienced with SQL, this does not stand for PostgreSQL. I have a table with the stucture approx: idorvos | integer | not null default nextval(('idorvos'::text)::regclass) nev | character varying(255) | not null...

how to disable or enable the constraint of a table i use the script "alter table tbl_name disable constraint const_name" but it shows the error parse error at or near "disable" at character 23

pls give the procedure to connect from VB.NET to PostgreSQL database