Search DaniWeb - pgadmin

Load .sql files into pgAdmin III 13 Years Ago by lewashby I just got postgresql & pgAdmin III up and running. I'M trying to start the book "Simply SQL" so how do I go about getting to .sql files for the book into pgAdmin? Thanks for any and all replies. How to make pgAdmin 3 show sql code automatically in the SQL Editor? 9 Years Ago by thorin … make so that when you click on some function in pgAdmin 3 and then click the SQL button on the top… update a function. I am using the same version of pgAdmin (1.16.1) and on the computer at work I… Postgres digest func inside procedure works on pgadmin but not in Laravel 5 Years Ago by azegurb … Sql** which deals about with hashing passwords. When used via **pgAdmin** tool it works like a charm as stated below. SELECT… have also installed extension **pgcrypto**. It works when called via **pgadmin** tool, but not inside **laravel** app as stated below my… psycopg2: database connectivity to PostgreSQL 15 Years Ago by PoovenM … program output) but when I query the database using the pgAdmin III SQL Query feature, I get no returned rows. I…. The following SQL statement working in the Query Editor from pgAdmin: [code=sql]INSERT INTO fdi.fdiresults (grid, index) VALUES (POINT… Free Navicat Equivilant? 16 Years Ago by samnav Does anyone know of a free tool or utility that I could use with pgAdmin III that would accomplish the same type of import functionality found in Navicat? security authentification using JDBCRealm under tomcat 6 and postgresql 15 Years Ago by artirt … postgresql using the following codes (that I've copied from pgAdmin): [CODE]-- Table: roles -- DROP TABLE roles; CREATE TABLE roles ( username… permissions issue in PostgreSQL 14 Years Ago by mmonclair … I'm not finding it. Any ideas? I'm using pgAdmin III to manage this database. Thanks much! Re: permissions issue in PostgreSQL 14 Years Ago by mmonclair … I'm not finding it. Any ideas? I'm using pgAdmin III to manage this database. Thanks much![/QUOTE] upload an image in jsp 12 Years Ago by 080346 … how i can store the image in my database(PostGreSql pgadmin iii) using jsp and glassfish as a server. i have… Unable to get response from Server 12 Years Ago by lordx78 Hi, I have virtual server in EC2 Amazon. Currently I'm using pgadmin to connect to postgres db in my server. Problem : Whenever I execute any queries (e.g DELETE), it will go on endlessly. But If you SSH into the server and check the result, the DELETE query has been successfully executed. Please advice. Thanks. Help with sql query involving not exists 11 Years Ago by cmstoner … know if you can. I am testing the query using pgAdmin. SELECT distinct w.name as Object, t.taggable_type as Type… Android simple database. 11 Years Ago by m1n1m3 …** as **server side** application. I have used **postgres SQL** with **pgAdmin** to develop a java web application as a part job… PostgreSQL Database Location 8 Years Ago by tqmd1 Dear Experts I am using windows 7 32bit. I have created database named "accounts" and 2 tables in it through pgAdmin III. The database is working well but I am unable to found it physical location on hard disk. On what path should I find it? Thanks Re: Postgresql Distributed Database 17 Years Ago by pty I believe [url=slony.info]this[/url] is what you're looking for. If you're using pgadmin then [url=http://www.pgadmin.org/docs/1.4/slony-install.html]this[/url] may also be of interest to you Re: PostgreSql 13 Years Ago by Slapo … might be disabled by default in older versions. I use pgAdmin, NetBeans, SquirrelSQL or SQL Workbench/J, depending on how much… I'm fed up with the lack of autocomplete in pgAdmin. If I don't want to leave the IDE, I… Re: MySQL Workbench, getting started 13 Years Ago by tesuji … which is available for all unix systems and by using pgAdmin III or TOra all examples from Rudy's book will… it: sudo /etc/init.d/postgresql-8.4 restart, then pgAdmin III chosen from developement menu, then create new user, password… Re: A Question.... and Question..... 15 Years Ago by R0bb0b … range anywhere from 1 hour to 6 months. 9. Dreamweaver, pgAdmin, phpMyAdmin, Zend Studio, Outlook, Notepad, WebDrive, TortoiseSVN, WinMerge. A few… Re: Update db 14 Years Ago by kireol … step 2)paste the code into a sql client like pgadmin or mysql or phpmyadmin, etc step 3) look for the… Re: PostgreSql 13 Years Ago by severman i tried to write plpgsql as language but he screams and tells me that he doesnt know this type of language. i'm using razorSQL. do u maybe know a good developer for ubuntu? pgadmin is terrible and so is phppgadmin Re: Explain plan of the query 12 Years Ago by dayoj Yep, definately a DB question. I use PgAdmin on PostGreSQL and utilise it's Query Planner regulary to fine tune some of my more complex queries. Re: Data not exporting to spreadsheet 9 Years Ago by Samyx Thank you. I am fairly new to web programming. I only tested the query directly into my pgAdmin and it returns the values I want. How can I test if the code is recognizing the query? Thanks Re: Load .sql files into pgAdmin III 13 Years Ago by tesuji Hi great! click on the SQL icon in the tool bar. the icon looks like a small magnifying glass or sometimes like a piece of paper with a pen (depending on the versions). I wish you good luck -- tesu Re: Load .sql files into pgAdmin III 13 Years Ago by lewashby I click that icon/button, click on each .sql file and click open, save, and then repeat until I have them all loaded into postresql, is that right? thanks. [QUOTE=tesuji;1318446]Hi great! click on the SQL icon in the tool bar. the icon looks like a small magnifying glass or sometimes like a piece of paper with a pen (depending on the … Re: psycopg2: database connectivity to PostgreSQL 15 Years Ago by jlm699 When using psycopg2 your operations are only transactions. In order to get your transaction to commit to the database you'll need to issue a [icode]conn.commit()[/icode] command. Re: psycopg2: database connectivity to PostgreSQL 15 Years Ago by woooee [QUOTE]I get no returned rows. I use the following SQL code to query: SELECT * FROM fdi.fdiresults;[/QUOTE]fdi.fdiresults seems odd for a table name. Try "SELECT tablename FROM pg_tables where tablename not like 'pg_%'" and see what it gives you for a table name. (Note that semicolons are not used in Python.) I am not familiar with … Re: psycopg2: database connectivity to PostgreSQL 15 Years Ago by jlm699 [QUOTE=woooee;655650](Note that semicolons are not used in Python.)[/QUOTE] When I was writing a data collecting application that interfaced with pgSQL via psycopg2 I tried out both ways (a query with and without a semicolon), neither of which threw any errors. And that line ...SELECT etc, is what he typed into his Postgres GUI, not python. Re: psycopg2: database connectivity to PostgreSQL 15 Years Ago by PoovenM Hi guys, thank you so much. Jlm699 was correct, I needed to commit the changes to the database. I knew that there was a commit call that has to be used but I was calling it on the cursor (cur) :icon_redface: And I agree, I haven't really seen tables being used the way I have (that is: [I]fdi.fdiresults[/I]) but it does work. The [I]fdi[/I] is the… Re: psycopg2: database connectivity to PostgreSQL 15 Years Ago by jlm699 [QUOTE=PoovenM;655776]Hi guys, thank you so much. Jlm699 was correct, I needed to commit the changes to the database. I knew that there was a commit call that has to be used but I was calling it on the cursor (cur) :icon_redface: And I agree, I haven't really seen tables being used the way I have (that is: [I]fdi.fdiresults[/I]) but it does work.… Re: Free Navicat Equivilant? 16 Years Ago by kenmurd Navicat is worth every cent you spend buying it. Most useful adddition to a PHP & MySQL developers toolbox. Give it a try. Re: Free Navicat Equivilant? 15 Years Ago by samnav I bought Navicat with $95 as an non-commercial user, it's cheap but powerful.