I want to do a crosstab query in PostgreSQL. Can you please describe how to do this in postgreSQL?
Hello
I have two tables 'item' and 'category'. Table item has a field categoryids
where i store the category id as comma seprated string.
And i am using the follwoing query to fetch the i...
I want to display some 3d objects in the graphics window from the database postgresql ...... The data about the objects are stored in the database postgresql.......
1,is it possible to conne...
We're looking for a way to emulate MySQL's "ORDER BY field()" function in Postgres. For example, we want to be able to return records in an arbitrary order, like so:
SELECT id from records ...
I'm attempting to backup to a Buffalo NAS which I can easily access in Windows Explorer.
Attempting to run the pg_dump command in a BAT file or directly in a CMD window gives a "The devic...
Here is the fragment of Postgresql 8.1 log - Windows 2003 server installation:
2006-04-13 10:30:33 tvman/tvman(10.0.1.197)LOG: unexpected EOF on client connection
2006-04-13 10:30:33 tvman/...
Hi,
when executing a postgresql function/stored proc (like an update) I would like to have as return value the number of affected rows. Could someone, please, help me?
Thanks,
...
Hi,
I have a server and i cant connect to it because it gives me the follwing error, the only thing i have changed inthe conf file was to allow certain ip addresses connect to it
We're trying to install postgresql-8.3.8-1-linux-x64 on an SLES 9 box, the install runs ok, but when it proceeds to configuring the database we're getting the following error
Invalid argume...
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 noticed that there is no sysdate in postresql
i want to execute following syntax: sysdate-2
i use current_timestamp but receive an error message below
DBD:: PgPP::st execute failed:...
How do you implement a GUID (Global Unique Identifier) in Postgres?
Any documentation (links) on how to do this?
Thanks
What does this error mean?
I wanted a field that incremented itself automatically, just like mysql's auto_increment attribute. So, I did the following in pg:
CREATE SEQUENCE mytable_i...
How to change postgresql auto-increment database field, similar to
"ALTER TABLE tbl AUTO_INCREMENT = 500" in MsSQL database?
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...
When I attempt to use the Configure Data Source wizard to set up advanced SQL Generation Options the options (i.e. add addtional INSERT, UPDATE... statements) are grayed out.
I found out w...
Would this translation be correct
Mysql syntax
CREATE TABLE `voicemessages` (
`id` int(11) NOT NULL auto_increment,
`msgnum` int(11) NOT NULL default '0',
`dir` varchar(80) default ...
in my development Linux server, i have postgres installed and am using the connection to my php web sites..,. after starting the postgress service exactly 5-6 hours.. the postgres server is ha...
Is there a way to get a history of queries/commands issued against a particular postgres database. I know that I can select * from pg_stat_activity, but this only shows queries as they are exe...
How do I escape special chars in PL/SQL in postgres. I tried to escape the apostrophe into XML escape sequence. I did something like this and got an error:
vAlias := replace(alias, '''', ...
I am looking for the syntax for the date function that works like dateadd in sql server that I can use in PostgreSQL.
Hi Experts,
Looks like a bug in Postgres - I just installed 8.3.1-1, hoping it was fixed... I added a column in PGAdmin III - I do a query (select * from mytable limit 1) and I get a row wh...
hello experts,
i'm using pgAdmin to interface postgresql,
i've create databases, my databases contains: schemas and catalogs,
but inside a schema there's the same elements than in a ca...
Hello,
I would like to know how I've to build and execute a dynamic sql query in a postgresql-function.
More details :
I've 3 parameters :
* Customer Name
* Customer First ...
Is there an equivalent of @@identity in PostgreSQL to automatically return the record just created?
Thanks heaps.
