We need to dump out a PostgreSQL database to import the data into another system. In trying to do that using pg_dump, we get the error "invalid page header in block 5963 of relation 'img_page...
I want to connect postgres with VC++ win32 console application in the plaform windows Vista so I have downloaded libpqxx-2.6.9 from internet........but the Read me text file does not give me ...
How to check the database name of postgres in my linux machine
i need to take the backup for that i have to give dabase name
i only know username and password ...
this is the command :...
I have a dump from a Postgresql database that I want to import into MySQL. Short of going through the whole thing (it's huge) and altering all the field definitions, is there any way to import...
Is there a way to grant access to multiple tables at once? I know how to create groups, but I have dozens of tables that need access by the developers (set up as a group) and read only access...
I have a table containing salesmen, structure follows:
CREATE TABLE agenti
(
id bigserial NOT NULL,
agent character(7),
nume character varying(50),
nrreg character varying(50),...
I used shp2pgsql.exe to create an import sql for my gis database.
The resultant sql has data like this in it.INSERT INTO "gis"."sa_area" ("label","type","level",the_geom) VALUES ('MÔRELIG','0...
Hi . . I've installed PostgreSQL 8.0, PgAdminIII and the Npgsql .NET data provider.
I've created a user, a database owned by that user, and set the database to accept connections.
I ca...
I am looking for the syntax for the date function that works like dateadd in sql server that I can use in PostgreSQL.
I get this error when I try to start postgres on Solaris 10
could not connect to server: No such file or directory
Is the server running locally and accepting
connections ...
I have 6 columns and there are a few row entries that are blank in columns 2 and 3. How can I find and replace those banks with '0's? I'm trying to use phpPGadmin to import a csv file into ...
Is there an equivalent of @@identity in PostgreSQL to automatically return the record just created?
Thanks heaps.
Using the Corelab's .net driver for Postgres in VS2005 to hit our production database. I've been developing against MS SQL server and using the Gridview Data Source wizard option to Generate t...
hello. im trying to query between dates for example:
select * from bookings where date between '12/28/2008' and '12/29/2008'
date is a timestamptz datatype.
how do i do this in postgres?
I currently have postgresql-7.4.8-1.RHEL4.1 and phpPgAdmin 4.0.1 installed. the phpPgAdmin tool see's the database but I keep getting a login failed with trying to login with the postgres user...
Hi Experts,
I am using the PG triggers. I have a library that sends the trigger events to a process. It works fine when I have small number of updates to generate triggers. If I increa...
Hello Expert
I am using PGSQL and created a table writing script which is.........
CREATE TABLE "TournReg" (
"RegID" int8 DEFAULT nextval('public."TournReg_RegID_seq"') NOT NU...
Hello,
I want to return 2 floating numbers from a PostGreSql pl/pgsql function.
What's a better way of doing it - A function returning a RECORD having 2 values? or a function returning SET...
Hi Experts
Can PostgreSQL installed on windows? is there any tech resources/web ?
Thanks
Dishan
We have a database that contains a forecast table. I need to take this table and copy it to another database (same server) every Friday night. The target database table can get overwritten. Is...
I am programing in VB6 and this is a postgreSQL db.
Below is the 2 tables that are setup in the db.
tblvrdata
vr_city - character varying(primary key) - 297 rows - Never Changes
vr_loc...
Platform: Postgre 7.x and PgAdmin III
tbltest table
Code:
CREATE TABLE public.tbltest
(
test_id int2 NOT NULL DEFAULT 0,
name text,
CONSTRAINT tbltest_pkey PRIMARY KEY (test_id)...
im trying to export from one postgres db to another but im having big problems
does any one know of a quick and easy tutorial for a novis linux user that explanes and shows me how to do a
...
The following is a PL/pgSQL boolean function that checks if a product can be found with a given department id, so that the department_id can be deleted altogether - it is used to avoid orphani...
I have this MYSQL code. This code creates a view in database asterisk and reads from another databse called openser.
CREATE VIEW vmusers AS
SELECT phplib_id as uniqueid,
username as ...
