Home : Bytes IT Community / View Full Version : PostgreSQL Forum

Pages : [1] 2

  1. Database gone a bit wild
  2. Converting PostgreSQL DB to MS-SQL DB
  3. create table MyVariable
  4. Global(shared) variable in postgresql
  5. need some help in function
  6. Installing PostgreSQL on WEPOS
  7. Running function as superuser
  8. PostgreSQL Database backup from a C# application
  9. weekday from timestamp?
  10. Bad date error
  11. day from date
  12. set Locale?
  13. Postgres to Oracle
  14. Dreamweaver CS3 , PostgreSQL and PHP
  15. Is index on column updated if the column is updated but data does not change?
  16. How can i use shared memorry in postgresql using c functions
  17. How to connect to a remote postgresql via http
  18. access or postgree
  19. Data Base Design
  20. large database
  21. (select Extract(dow...))
  22. Can I know the disfference between postgres restart and reload?
  23. Passing tablename as argument into function
  24. select not using index
  25. connection statement
  26. Problems with empty sets?!
  27. Exception::=>>Object or Provider is not capable of performing requested operation
  28. shared buffer cache monitoring
  29. PostgreSQL to Oracle migration
  30. Postgres "could not write to hash-join temporary file"
  31. Not showing the rows which is having the digits < 6 !!!
  32. ALTER TABLE command?
  33. psqlodbc
  34. Postgres can't talk on TCP/IP connection
  35. Writing a user defined function
  36. database backup to include circular dependencies
  37. Restore data without any backup file
  38. calling functions which are stored as values in a table
  39. Postgres Service start fails
  40. Automatic deleting views of table in PostgreSql
  41. connection to openOffice.org database
  42. checking if the Database exists (by running a batch file)
  43. PostgreSQL object datatype
  44. Triggers in postgres
  45. using a dictionary with Npgsql
  46. Searching across 155 tables
  47. Migrating from Oracle to PostgreSQL
  48. one trigger for two different tables
  49. DB Synchronize
  50. table name as a column datatype
  51. Scalability issues....
  52. Customers of PostgreSQL
  53. how to make this function work....
  54. Execute statement in postgres
  55. Can postgres functions return multiple values???
  56. find the position of character in a string
  57. how to build the source of postgresql 8.3.1 for windows
  58. libpostgres.a
  59. primary key problem on delete
  60. change the datatype of a field
  61. postgres in java
  62. change ownership
  63. a problem of function return setof
  64. Disabling Autocommit
  65. Unable to restore postgres-dump-Version-8.2.4
  66. Transaction Isolation Level
  67. offset, limit problem
  68. max count
  69. connection problem
  70. on a table
  71. postgres server recovery
  72. What is the best free Postgresql frontend available ?
  73. Error restoring bytea from dump
  74. how to add/merge varchar2s(Strings) in PL/SQL
  75. Can anyone help me to writ a function in postgresql
  76. How to writ function in postgres?
  77. 'case column' in HAVING clause
  78. Need help on how to backup a table!!!
  79. Help inserting record to PG with MS Access frontend
  80. ERROR: column "dtype" of relation "xxxxx" does not exist
  81. Inheritance problem
  82. Execute A Psql Commands Through Batch File (*.bat)
  83. How to change character encoding of an existing database
  84. How to close Opened Connections to 'Postgres'?
  85. Size of the database
  86. OdbcDataAdapter Insert Command
  87. datatype
  88. shapefile database
  89. interface - python - postgresql
  90. Details
  91. Compilation error "Absent rule for target assemble `utf8_and_shift_jis_2004.o'"
  92. PostgreSQL multiple databases
  93. postgre vs MySQL
  94. how to view output of postgreSQL function?
  95. Connection to postgres database failed
  96. Internal Server Error in connecting Postgresql Server
  97. Nonclustered indexes
  98. PHP or PostgreSQL problem?
  99. HELP: Indexes
  100. Postgresql Upgrade from 8.1 to 8.3 on windows
  101. how to run postgresql on debian terminal
  102. Abort transaction due to error
  103. Running two different versions of PostgreSQL
  104. pl/pgsql triggers - Problem with NEW.*
  105. Help.. Npgsql with .net
  106. changing postgres code
  107. Copy data with several delimiters
  108. How to convert date format in PostgreSQL
  109. Keeping cursors across page reloads/changes
  110. get back deleted data from a table in postgres
  111. AutoBackup Available in PostgreSQL
  112. inserting time into postgres
  113. sample database
  114. regular expressions
  115. plj help
  116. Returning 0, possibly OUTER JOIN???
  117. how to declare the cursors in a stored procedural function
  118. hi
  119. Problem in closing connection in postgresql
  120. export data in excel format
  121. importing into postgreSQL from oracle
  122. Reg Update Local Server to Remote Server
  123. postgreSQL installation problem
  124. database problem
  125. Features And Data Management Strategies Of Postgresql
  126. Not able to drop the database in PostgreSql Server
  127. pg_dump, pg_restore
  128. extracting a month
  129. Issue With COPY TO STDOUT / COPY FROM STDIN
  130. Trigger problem
  131. More Constraints
  132. PostgreSQL connection in CGI-PERL Script
  133. Advanced Constraint
  134. How to read the content of psqldump
  135. Comparison of Open Source databases
  136. How to find duplicate values exists or not
  137. postgreSQL restore problem
  138. Where can I find detailed information about pl/python?
  139. pg_dump: SQL command failed
  140. how-to - trigger function with argument / parameter
  141. user defined data types
  142. transfer tables from postgre to oracle
  143. Connectivity to postgres from asp.net
  144. How to synchronize data from Postgre to cache
  145. Conversion of MySQL spatial query with intermediate tables to PostGre spatial query
  146. SQL server to Postgre
  147. how to transfer datas from oracle to postgre
  148. how to transfer datas from postgre to oracle
  149. Reg Windows Master Linux Slave
  150. Prepared Statement for IN function
  151. i18n support in Postgresql
  152. Postgre subquery help
  153. Rounding Problem in Stored Functions
  154. Input file:permission denied
  155. constraint problem
  156. Relation Does not Exists
  157. Reg Incremental Backup and Restore In Postgres 8.1
  158. to connect PostgreSQL from VB.NET
  159. The "first day" with PostgreSQL and trouble with this
  160. Copy select query result to a file
  161. PostGreSQL Clustering Installation
  162. Postgre with vc++
  163. Sending array from JAVA code to Postgre
  164. indexing, limit problem
  165. Reg Postgres Data Base Server Will Be slow
  166. After OS upgrade from XP to Vista postgre user password does not work
  167. COPY command error
  168. Basic Question - Open Source DBMS
  169. Converting an Access database to Postgresql
  170. Image field in SQL Server 2005 to lo field in PostGres 8.2
  171. database cluster for general user
  172. execution of python function from a postgresql stored procedure
  173. retrieve problem
  174. Relation one-to-one-of
  175. Function returning uple?
  176. How to get password once from user and use that in entire MSDOS batch file.
  177. in postgres sql
  178. when restoring the dump in postgresql 7.3.4, no functions are available
  179. How to enable PITR on all POSTGRES server
  180. Batch file + psql problem
  181. getting started with v 7.4
  182. how to append the string to SQL queries in stored procedure of Postgres....
  183. Creation and modification timestamp
  184. to change datatype
  185. Problem in converting float4 type to float8
  186. postgreSQl chennai trainingc enter
  187. returning columns from different tables, in plpgsql function
  188. Names of columns with foreign keys
  189. Error: relation with OID 22938 does not exist
  190. how to qeuey this in paadmin like mssql
  191. Can you use a stored procedure in a subquery in postgres?
  192. Installation fails
  193. Encoding problem in create database
  194. Address already in Use, postgres doesnot restart
  195. Restoring the dump in a new database does not contain oids
  196. Selection in pgsql using dynamic tables.
  197. Table Creation Problem
  198. Connecting to PostgreSQL using VB.NET
  199. BYTEA convertion to TEXT
  200. PostgreSQL Tablespace Creation Problem
  201. doubt in CASE command
  202. Can I connect to remote DB using psql?
  203. Installation Problems with Windows XP
  204. return type of function wen having different datatypes
  205. round to the nearest integer
  206. Is there a PHP cursor?
  207. Bitemporal tables sequenced unique triggers
  208. postgresql
  209. syntax to view the structure of a table using sql
  210. getting tuples of result
  211. how to configure Pgpool-II to replicate postgres database in linux
  212. Restore from plain text
  213. Problem in executing sql file
  214. trigger problem
  215. double quotes inside single quotes => ' " ... " '
  216. plperl problem
  217. How to setup a Arabic compatable Postgres DB
  218. postgreSQL user permission denied
  219. Postgresql database connection error...
  220. doubt in update query inside a function
  221. CREATE LANGUAGE cannot load library
  222. Need help with a slow UPDATE query
  223. PostgreSQL logical storage
  224. pg_restore in C - language how to...
  225. Physical files
  226. Problem in Select Query
  227. PostgresSQL server connectiong problem with C-language...
  228. Transactions
  229. converting POINT(-43.16 -0.876) to Latitude and Longitude
  230. doubt in exporting a file into database
  231. datamodel
  232. executing a query daily
  233. Error in following query
  234. PG archiver problem
  235. PostgreSQL dump restore from client
  236. Online replication of Postgresql databases
  237. Performance Tuning
  238. Postgresql Reinstallation problem on Windows
  239. problem in using unicode datatype
  240. current transaction is aborted. queries ignored until end of the transaction block
  241. Problem regarding a function
  242. install postgre
  243. install postgre
  244. why did not suppert Rollback? postgresql
  245. doubts in slony
  246. difference
  247. PostScript Reports
  248. stupid misstake with DB encoding
  249. Query about 20,000 record problem(slow)
  250. Problems with unique key constraint.(CASE INSENSITIVE)
  251. Insert data in win1251 encoding to base with utf8 encoding
  252. Problem inserting into a view
  253. Updating a coloumn value by comparing coloumns from two tables
  254. Top Value in a Table
  255. PostgreSQL equivalent to MySQL LOCATE()
  256. pg_dump backup doesnt restore everything - things missing... restore howto required
  257. Using the result of a function that RETURNS SETOF
  258. doubt regarding rollback
  259. database connection problem
  260. logically-delete a row rather than actually remove in from table in postgreSQL
  261. Restore after server crash
  262. Add not null column in a table
  263. Rules in Postgresql
  264. FATAL: role "root" does not exist
  265. postres triggers
  266. Problem: Retrieving Records based on the From & To Date
  267. doubt in arrays used in function
  268. PostgreSql Documents
  269. how to move the data ,because of the partition table
  270. doubt in function
  271. MySQL and PostgreSQL
  272. Reading into FoxPro via psqlODBC
  273. how can we use partition table ?
  274. Combining two fields data into one field in the same table
  275. Need Help In Postgres
  276. COPY Query fails in postgre release 8.2
  277. how can i use the initdb?
  278. Optimal architecture for a postgres DB?
  279. Open Source Application Server (PostgreSQL Perspective)
  280. function in postgreSql
  281. How to speed up a query
  282. Cannot change column data type
  283. query the results of a table function applied to all the rows of a different table
  284. Project On Postgresql
  285. features and data management strategies of PostgreSQL
  286. Duplicate a DB
  287. how to retrieve number of fields in the table
  288. Installation Issues
  289. Lock Problem
  290. How to create Function for executing query ....
  291. DISTINCT or GROUP BY don't seem to help
  292. Multiple Group by
  293. ERROR : relation "master"
  294. Error while running createdb from a batch file in windows xp
  295. Are queries different between sql and postgresql?
  296. Integer array in where clause
  297. copy command
  298. Partitioning database in Postgres
  299. how to get column names of a table
  300. copy command
  301. Using cursor for update
  302. Enterprise Wide Deployment
  303. syntax for copy command
  304. Benchmarking tools for PostgreSQL on Linux (fedora)
  305. ERROR: return type mismatch in function returning tuple
  306. ERROR: SELECT query has no destination for result data;
  307. inserting data in time field
  308. Get the generated value of serial type field (primary key)
  309. Slony-I questions
  310. Select For Update
  311. Function To Return Insert Statements In Postgres
  312. Extract date from timestamp
  313. Exporting data from postgresql to oracle
  314. Is there separate package for client and server in postgresql
  315. Server - Client Application
  316. doubt in a datatype
  317. syntax to view the structure of a table
  318. Is Pg replication used for multi master or two master asynnchronus replication
  319. explain
  320. ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist
  321. Cant view table description
  322. PGCluster-II version 1.3 implementation
  323. Error:: 'more' is not recognized as an internal or external command
  324. What replication are people using
  325. Import data into Postgresql
  326. how to post to the forum
  327. Understanding End of Cursor?
  328. A far cry - but here's hoping - PostgreSQL Replicator
  329. Too many clients already
  330. Installation of PostgreSQL on Windows XP
  331. Help with Tags database design.
  332. retrieve two tables in a single query
  333. Returning SETOF in plpgsql
  334. oid problem
  335. How to add a column to the table
  336. Convert data from char type to byte tape
  337. Stored functions
  338. Mapping select results through a function
  339. Stored functions books
  340. I couldn't install 8.2 ( Instead of I got a lot of Error messages :)
  341. alias name inside the function
  342. What is the output statement in PostgreSQL
  343. Regarding Installation of postgresql as a client - server
  344. syntax error at or near "TYPE"
  345. Postgresql supports Map Info's Easy Loader and MapXtreme-- Java
  346. Hybrid Environment
  347. Too Many Client Connections -- Error -- Need Help
  348. Hello everyone, I am new to this site and SQL server
  349. Building an aggregate function
  350. "is not scalar Variable" Error
  351. scripts for converting dbf or mdb files to postgres
  352. array parameter in plpgsql function
  353. Keeping two db's in synch across continents
  354. order by for varchar datatype column with numeric values
  355. Functiion Problem
  356. starting psql in windows
  357. Postgres backup and restore
  358. PostgreSQL Database Backup at System Shutdown time in OS Windows XP
  359. shp2pgsql Help with syntax
  360. pg_restore is not recognizing dump
  361. maximum function
  362. What is commit_delay & commit_siblings?
  363. Problem with function
  364. Start of Year
  365. migration tool
  366. All About - PostgreSql
  367. PostgreSQL and OleDb
  368. Need help with triggers
  369. Pgsql 8.4 on Vista starts and stops automatically.
  370. bulk copy from flat file to postgres dbserver
  371. output parameters in functions
  372. Postgres 7.x and Legato backup
  373. Postgres8.1 Database Server could not be started
  374. How to store binary files in the PostgreSql database table?
  375. How PostgreSQL searching Queries?
  376. Constraints vs Indexes
  377. Create function question...
  378. Transaction Problem
  379. Improving date(timestamp) searches
  380. crystal report
  381. How to set TG_ARGV values
  382. USE OF VARIABLES IN postgreSQL
  383. How to replace characters in dblink
  384. getting latest filled row
  385. problem with date
  386. How to get column name
  387. Auto mail sending using postgresql
  388. syntax is not supported error
  389. need an sql query for the following situation
  390. Copy Table to other database
  391. Cannot compile plpgsql function
  392. pg_dump Failure
  393. Aggregate/concatenate function (flattening columns into a row)
  394. Temporary tables
  395. User and Role
  396. How to copy data from one table to other table
  397. Function declaration for MSFTSql developer
  398. function execution
  399. using array data type
  400. What would my SQL statement look like?
  401. Database connection problem
  402. Error Installing PostgreSQL 8.1.9 on XP
  403. no lock
  404. unsorted column
  405. how to convert a query from SQL to HQL(hibernate Query Language)
  406. Beginning with PostgreSQL
  407. How to configure static ip PostgresSQL 8.1 for windows XP system
  408. How to find out that SSL is activated
  409. Postgresql 8.2 connection problem on static ip
  410. Stored Procedures in PostgreSQL
  411. execute funtions in psql
  412. SUM with possible NULL values
  413. Connecting to PostgreSQL through SSH (putty)
  414. Exporting tables from Postgres to SQL
  415. Installation of PostgreSQL 8.0 on Solaris10
  416. Stored procedure
  417. problem in querry
  418. Adding new column to existing table
  419. Support for ROWNUM and ROWID
  420. Size of table and size of database
  421. Use Of Dblink
  422. how to export postgresql tables
  423. psql won't connect, though other clients are OK
  424. Serverless/embedded PostgreSQL database
  425. Date difference
  426. count months between two dates
  427. 24 hour time format
  428. Substract hour into a function
  429. import Excel to postgreSQL
  430. Retrieve number of rows in table
  431. Invoking psql at command prompt
  432. Migration from SQL Server to PostgreSQL
  433. How to recover the deleted fields with values from bakup.
  434. recovering fields in tables
  435. Postgres Violates Primary key and OID
  436. hai i am new here.i have question,please give me reply as soon as possible
  437. Function returning setof
  438. PostreSql function
  439. Migrating IBM Universe Database to Postgres, date format Problem
  440. Run Unix Shell Scripts With Postgres Trigger
  441. server closed the connection unexpectedly
  442. getting current date
  443. For Report Generate
  444. Usisng PQgetvalue
  445. Database Design Help
  446. Need help with query involving automatically decaying values
  447. psql copy
  448. Getting Parse Error at or near and at character......
  449. Variable column name
  450. Transfer of Data from Oracle to PostgreSQL
  451. create database if not exists
  452. data fetch and insert
  453. Oid
  454. Foreign key problem
  455. How to assign a primary key
  456. pg_restore doesn't work for postgresql 7.2.3
  457. How To Execue Queris Fastly
  458. Posting Guidelines. Please read before you post in a forum!
  459. Inheritance Problem
  460. Help : what this Error means
  461. Installing PostgreSQL 8.1 on VISTA
  462. load balancing
  463. how retrive this problem
  464. Problem in function with CREATE ROLE with parameters
  465. BackUp and Restore PostGreSQL8.1
  466. HOW TO exit from a query
  467. controlling postgres I/O and CPU processing
  468. performance tuning postgres 8.2.3 on windows with shared server applications
  469. Retrieving values from tables
  470. stored procedure in postgresql
  471. Problem with Windows PostgreSQL 8.1 service
  472. download old version of PG
  473. restore problem
  474. how to compare two tables
  475. what is the keyWord DELETING
  476. Strange result using transactions
  477. How to Upgrade Postgres 7.x.x in RH9 to new Postgres version 8.x.x ??
  478. Postgresql installation problem??
  479. php objects in postgresql
  480. odbc call failed
  481. Starting More Than one Transaction
  482. Fatal error: Call to undefined function pg_connect()
  483. Connection Exception
  484. joins
  485. How to know the Number of Connection made with the database
  486. how to write the select query for this situation
  487. C# .NET ===> postgreSQL
  488. Pagination in Postgre
  489. Test Suite for Postgresql
  490. How can I display the stored image?
  491. Storing files in Postgresql database
  492. Interface to posgresql
  493. How to check a query execution plans in PostgreSQL
  494. HOW TO merge two strings
  495. need copy table sql example in postgres
  496. use of client-side \lo_import and \lo_export commands
  497. Server doesn't listen
  498. SHA function?
  499. Fastly Inserting Records
  500. how to release locks when instance crashes
  501. HOW TO Use transaction control statements inside a sored procedure
  502. Back Up And Restore
  503. Functions and Commits
  504. how to write this sql statement
  505. Nested use of found doesn't seem to be working
  506. Alter table doubt
  507. Driver for postgresql
  508. Redundant data in postgres
  509. Migrating data between dbs with different schemas
  510. Postgres Newbie - Case Problems in queries
  511. Multi dimensional arrays, sub selects...
  512. Error When creating the table
  513. String was not recognized as a Valid Date Time
  514. Postmaster is accepting TCP/IP connections error
  515. Data Migration From Excel to PostgreSQL
  516. date queries with portions of the date unknown
  517. How to Fix Corrupt Tables
  518. Unable to connect
  519. Postgresql Compression Across Network
  520. limit database size
  521. limit database size
  522. query and subquery in python
  523. retrieve column array values
  524. how to execute script from file within function
  525. retreive values from an array into column
  526. Can PostgreSQL initiate a message through a socket?
  527. how to insert image
  528. which is the best interface for postgresql
  529. unable to set 'Owner' column to different role
  530. username
  531. inserting values into array column
  532. Query regarding odbc connection ??
  533. how to give login in a table
  534. limitation of postgresql
  535. how can I fetch data from the database and display it in form of a editable html form
  536. ALIAS error
  537. postgis function
  538. FATAL ERROR on Solaris 10
  539. postgresql function
  540. invert an array
  541. postgresql installation fails on windows 2000
  542. accessing last element of an array
  543. How to cast varchar into timestamp in postgres
  544. How to make a copy of data in RAM ???
  545. update multiple cols in trigger
  546. How to make cross-database reference in Postgres
  547. nesting joins
  548. How to insert multiple sub columns inside a column ??
  549. on delete set null problem
  550. Databinding bool fields