I have a large query in a PostgreSQL database. The Query is something like this: SELECT * FROM table1, table2, ... WHERE table1.id = table2.id... When I run this query as a sql query, the it returns the wanted row. But when I tries to use the same query to create a view, it returns an error: "error: column "id" specified more than o...
I have a table in my pgsql database with columns named "type", "desc", and "start". When I call $dbh->column_info, only "desc" comes back quoted, whereas in pgAdmin3 all three of them are quoted. Is one of them wrong? ...
Hi all i install postgre on my localserver(ubuntu) with ip 192.168.1.10 and now try to access the database from my client machine(ubuntu) with ip 192.168.1.11 by pgadmin please guide me....actually i know i have to make changes in postgresql.conf to allow client ip and pg_hba.conf ...
Hi people, How can you import to a table in PgAdmin III from an excel or CSV? Command copy works only when the file is in the server! :S ...
Hi, I have a posgreSQL database and I am using pgAdmin III to work with it.I created a sequence called primaryKeySequence. Now I want to use this sequence as the default value for a primary key field in a table. I tried to insert nextval('primaryKeySequence'); into the default value textfield in pgAdmin. When I click the 'OK'-butt...
In SQL Server I could copy sql code out of an application and paste it into SSMS, declare & assign vars that exist in the sql and run.. yay great debugging scenario. e.g. (please note I am rusty and syntax may be incorrect) declare @x as varchar(10) set @x = 'abc' select * from sometable where somefield = @x I want to do something si...
I am failing in creating tables via the PGadmin III SQL editor - even if the syntax is generated by the frontend: CREATE TABLE testtable ( id integer, "name" character varying(100) ) WITH ( OIDS = FALSE ) ; Error message is in german, but basically says that there's supposed to be a syntax error.. FEHLER: Syntaxfehler bei ...
I have a few database servers and few developers. I have set-up database connection definitions on my PC for each servers and now I want to share with other developers but I was not sure how to export and import the definitions. I am running PGAdmin3 1.10.2 on Ubuntu 10.04 (lucid). Regards ...
Dear friends, i am trying to use tinyows for wfs-t in my app along with openlayers and postgis. i am using osm tables and myown tables for storing geom. tinyows working fine with osm tales, but returning table_name.(null) as fid for requested features. so i am unable to do wfs-t on my tables. How to solve this error, where is my mistake...
I had the debugger working in pgAdminIII at one point, some time before upgrading to 9.0, but as of right now I can't seem to get it working using the usual steps. I believe it may have something to do with the DLL not loading correctly, because the following query: LOAD '$libdir/plugins/plugin_debugger.dll'; show shared_preload_librar...