220 Topics
 | |
 | More programming fun! OK this time around I'm trying to create a table with the statement, CREATE TABLE tablename ( recnumber SERIAL PRIMARY KEY, recordvalues VARCHAR ( 500 ) NOT NULL, datecreated DATE ) And it basically works, and I can add records using the dba account. However when I … |
| | How do I create a table in postgres that's associated with a specific database? Obviously from the command line one can do Create table tablename (); But how do I make sure that the table is associated with the correct database? CREATE table dbname.tablename(); is giving me the error: ERROR: …  |
| | In recent years, open source software, and open source community construction is more popular, such as: mysql, postgresql, and openGauss database open source communities .So, as an individual, how to specifically participate in the open source community contribution?  |
| | What is the difference between openGauss and postgresql in the key technologies?Can you elaborate on this from the following points (including but not limited to): runtime model, transaction mechanism, data storage and organization, query optimizer, etc.  |
| | What is the difference between openGauss and postgresql in the key technologies?Can you elaborate on this from the following points (including but not limited to): runtime model, transaction mechanism, data storage and organization, query optimizer, etc. |
 | # Introduction # As we move into 2022, businesses will continue to look for ways to become more data-driven. This means that knowing how to use Structured Query Language, commonly called SQL or 'Sequel', will remain an essential skill for data scientists, analysts, and developers. In this post, we'll provide … |
| | The web application will have a database that consists of millions (over 20mil ... maybe 100mil or more) of hosts (ipv4,ipv6 and domains) and additional data to each host like blacklist, uptime, history, geo data (country, region, city, isp). I could, of course, use other RMDBS system like MySQL, Oracle, …  |
| | Consider the following database Room (room_no,room_name,room_type,charges) Guest(Guest_code, Gname,city) The relationship is as follows: Room-Guest: one-to-one. room_type can have values as either ‘AC’ or ‘NonAC’. Q 2) A Create the above database in PostGreSQL and insert sufficient records. |
| | Hi everyone! Do you know how to create Pizzeria Program using Python and PostgreSQL where it can keep track of the pizza orders and view the order information using Python and PostgreSQL? Technology needed: -Django for the program -Postgresql for database How it can be used: Every time there is … |
| | Hi there, recently I have created stored procedure in **Postgres Sql** which deals about with hashing passwords. When used via **pgAdmin** tool it works like a charm as stated below. SELECT horeca_user.update_token( 1, //user_id 1, //type 'sdsfsdfs' //token ) I have also installed extension **pgcrypto**. It works when called via … |
| | Hello everyone How to fetch data from PostgreSQL to WXpyhon GUI to automaticaly open the next processe ? Thanks |
 | Hi there, I would love to make a list and have a collection of database servers, could you all please help me? It would be nice if you could provide a link to their homepage. If you post, I will update the first post. [list] [*]MySQL ([url="http://www.mysql.org/"]http://www.MySQL.org/[/url]) [*]PostgreSQL [*]Access [*]MSSQL … |
 | I understand how to generate objects from the database, using Sinatra with formatting, and I understand from tutorials how to use POST to send information back, but I don't understand how to use POST to transfer information from the browser (for instance from a text field, or inside <p id="stufftotransfer"><%= …  |
 | how to fetch data from PostgreSQL to WXpyhon GUI to automaticaly open the next processe ? |
 | I have been trying to insert,update,delete,select with separate queries.But when i try to write a query after a pre-written query i get an error that the string is predefined.I am working on a PBL project so i have to show all that in one program itself. Here is the current … |
| | Hi, I am developing a mobile app for a health care institution. I'd like to get a suggestion on how to approach my database design. There are many user types of this app; residents, nurse, and general-staff. The "resident" has many information that other types don't have; unit_number, food_allergy, emergency_contact, … |
| | Hello , I wanted to ask if for these statements in mongo: collection.find({},{}).toArray(function(err, result) { collection.find({email : req.user.email},{}).toArray(function(err, result) { the equivalents in postgresql are: client.query( "SELECT * FROM theTable ", function(err,result) { client.query( "SELECT * FROM theTable WHERE email = 'req.user.email' ", function(err, result) { result should be automatically … |
| | Hello ,I want to ask how can I succeed an analogous from mongodb to postgresql. app.post('/myjob', function(req, res) { var collection = db.collection('theDB'); collection.insert({ "my_id" : myID, .... }, function (err, mes) { if (err) { res.send("There was an error"); } else { console.log("Ok with ID "+myID); res.send({ "Done!", ID … |
| | 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  |
| | Hi, I am writing a code to dynamically create a table and then add delete and modify records. The table is created from an existing database table. How ever the add and the deleting of records is not wrking. I think there is some error in the query statements. Please …  |
| | Hi, I am working in a company that utilises many systems with their own databases. For example, the cafe has its own CAFE system with its own database (it could be postgresql). The Health Care system has its own database system (it could be MS SQL). The Transport booking has … |
 | Hi there, I'm a long time PHP programmer, 6 month newb python developer, but entirely new to git and gitlab. I've spent 2 solid work days trying to solve this issue, I've chatted with others in chat rooms, all to no avail. I'm not certain where I should post this … |
| | i have a table tbltrans transno | agent name | date | --------+-----------+------- 1 01 | waw |2014-10-10| 1 02 | waw |2014-10-15| 1 03 | waw |2014-10-20| 1 04 | waw |2014-10-30| i want a query for postgresql that calculate the average time for agentname the result is like …  |
| | Hi I am getting a **HTTP Status 500 - An exception occurred processing JSP page /registration.jsp at line 15** error. The page is a registration jsp page that submits the following parametres into the database. However there are no hints in Eclipse as to what caused the error. Can someone …  |
 | I have been creating small personal projects and trying to monetize or just learn from the creation process. I love programming and I am doing it as a hobby, looking forward to become a strong developer as soon as possible. Starting out I used Joomla, Wordpress, Drupal as CMSs but …  |
| | Hi All First post. PHP/PostgreSQL newbie... I'm trying to create a simple web page with a dropdown menu. The values for the dropdown menu are retrieved from a database table. The code I've got is... <html> <body> <select> <?php $db = pg_connect("host=hostname port=5432 dbname=dbname user=user password=password") or die ("Could not … |
 | Hello Guys, Good Day. I have this kind of error `OperationalError: no such table: table_name` when I make a query like `modelname.objects.all()` in **manage.py shell**. But I already did the ff: 1. settings.py > Databases > django.db.backends.postgresql_psycopg2 DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'), }, 'db_foo': { … |
| | hai.. i need to get all tables names from my database.i am using postgresql.what is the query for selecting all table names..please help me |
 | The world's largest technical support, software and hardware companies use Linux on a daily basis for a variety of tasks and solutions. This post gives you an overview of all the ways in which large companies use Linux. Most don't use Linux on the desktop but do use it in …  |
 | Structures of my tables are as follow. Table Name : timetable [Image1](http://www.4shared.com/download/MYafV7-6ce/timetableTable.png) Table Name : slot_table [image2](http://www.4shared.com/download/9Lp_CBn2ba/slot_table.png) Table Name : instructor(this table is not required for this particular problem) I want to show the resultant data in my android app in a timetable format somewhat like this: [image3](http://www.4shared.com/download/oAGiUXVAba/random.png) **Question** : … |
| | I am converting a PHP application from MySQL to PostgresSQL. The MySQL works flawlessly. The database for this application is a one to many relationship. I have a while loop nested inside another while loop <?php while ($movie_row = pg_fetch_array($movie, PGSQL_ASSOC)) { ?> [html code to echo various elements of … |
 | Hello guys!! I have a database and I store public tweets inside. I have lots of columns, including timestamp with timezone column. For example: timestamp | tweet_id "2013-07-30 11:14:07.404+03" 6598dsf4466a "2013-07-30 11:14:08.028+03" 87f9dss99s97 ... "2013-08-04 17:36:37.924+03" 646s4f64a64 "2013-08-04 17:36:38.891+03" 654asd9f654a So, I want to make clusters (time clusters) with these … |
 | I have a program that takes csv values, parses the content and inserts it in an sqlite3 database. I am using sqlite3 to save on space and to make the py scripts a little more portable. The next refactoring may well need to have postgresql or mysql to deal with … |
| | Hello, I'm working with PostgreSQL and Python to obtain 2 columns froma database and need to print it in a specific format. Here is my current code. #!/usr/bin/python # -*- coding: utf-8 -*- import psycopg2 import sys con = None try: con = psycopg2.connect(database='DB', user='ME', password='1234') cur = con.cursor() cur.execute(" … |
| | Good day I’m new with JSP, here the problem, I just converting the code from SQL to PostgreSQL, but a problem occur after I change to DataSource ds = (DataSource)envCtx.lookup( "jdbc/postgres" ); and add a scheme to the query. By theory it should be ok but it produce this error … |
 | SELECT getdatabaseencoding(), current_setting('client_encoding'), current_setting('lc_ctype'), current_setting('lc_collate'), version(); returns UTF8 UNICODE C C PostgreSQL 9.1.7 on x86_64-unknown-linux-gnu, compiled by gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 64-bit select lower('ČĘĖĮ') returns ČĘĖĮ Actually what I want is to seach surnames with ILIKE which is not working for those chars. WHy this can be? |
| | I have a CTE based query, to which I pass about 2600 4-tuple latitude/longitude values using joins - these latitude longitude 4-tuples have been ID tagged and held in a second table called coordinates. These top left and bottom right latitude / longitude values are passed into the CTE in … |
| | Hello friends , I have two questions : 1) I was using psycopg2 for old versions of python 2.x , and now while using Python 3.3 , i can install psycopg2 , maybe it needs a special psycopg for Python 3.3 . 2) I could install py-postgresql , and i … |
 | I am looking for a universal system that can replicate/Synronize database schemas and changed data for mysql,sql server,Oracle or atleast mysql and postgresql. Our company has different branches each with its own local data but any changes in a local database is supposed to be replicated to the central database. … |
| | Hi. I installed postgreSQL-7.4.6, apache2 and PHP-4.3.9 on Fedora Core 2. I wanna access postgreSQL from php, but got such an error: Fatal error: Call to undefined function: pg_connect(). And then I try to reinstall php: ./configure --with-pgsql=[pgsql DIR] make; make install; cp php.ini-dist [php DIR] set extensions directory and … |
| | Hi Thgin i seek is to create a connection (android) to the latest postgresql 9.2 database. Theat is running on a distant server. Can i Do it? Is postgre 9.2 JDBC driver fro andoid out? & little bit distant question. If the prevous is doable. How i an write tet …  |
| | # NOTE # This was a PHP sticky, and I am working to turn it into a development sticky. If you have any comments, additions or other observations, please reply to [this thread](https://www.daniweb.com/community-center/daniweb-community-feedback/threads/505442/read-this-before-posting-sticky). # Before you ask # - Read our [Forum Rules](https://www.daniweb.com/welcome/rules). - Engage your brain! We understand that … |
| | Hello, i would like to know what happens at the backend(access to remote database), when someone clicks check availability on a, say an online travels, hotels, flights booking page, and he gets informations like if the rooms or flights are available on so and so dates and things. I would … |
| | I have a Delphi 2010 DLL using AnyDAC (version 6.0.2 (build 2653)) TADTable components. When I SetRange on any table in a PostgreSQL database, I get "Assertion Failure" error. This only happens in the dll - copying the code to a simple exe, I don't get the error. I am … |
| | Hi There; I have a ASPX file and a code-behind cs file. I try to connect to a postgresql, perfom some database issue, and disconnect from it finally. To name a few, I print all records of database to the html file, add some new records. All these operations are … |
| | Hi everyone, Im new to web programming and i need some help, I have something like this: <td><label>User (Login): </label></td> <td><input class="textbox" autofocus="true" type="text" maxLength="7" name="cUser" id="cUser" /></td> </tr><tr></tr> <td><label>First Name: </label></td> <td><input class="textbox" type="text" maxLength="20" name="cFname" id='cFname' value=""/></td> </tr><tr></tr><tr> <td><label>Last Name: </label></td> <td><input class="textbox" type="text" maxLength="30" name="cLName" id="cLName" /></td> … |
| | Hi, I am in urgent need for converting sql procedure to postgre sql procedure.Please help me ASAP. CREATE FUNCTION sp_get_id_des (IN cellid INT, IN mcc VARCHAR(3), IN mnc VARCHAR(3), IN nwtype INT, IN mlac INT , IN mrac INT ) returns SETOF record AS' declare pscnt int ; declare cscnt … |
 | Hi everyone, I'm going to start using PostgreSQL, but I'm a newbie, never used it before. I have only "played" a little bit with MySQL. I was wondering if besides de online documentation you would recommend a good book on PostgreSQL 9.1.4? Thank you very much, Ricardo, |
| | I did a page for adding and viewing activities in a project. The table linked with that page has an UNIQUE constraint for the activity code. As a result of which when i add a new activity with existing Activity code, it is not accepted and gives a runtime error …  |
| | I need query tool, which has one simple function - to be able to execute different queries not commending out another queries. This is so annoying, how those another software can not have this simple feature, like pgadmn does not have (I guess), dreamcoder does not have, have just tried … |
The End.