• How to hide rows in PostgreSQL database

    In my PostgreSQL database, I have to hide several rows (instead of deleting them). However, I still want to retrieve them. How can I go about this?

    ITKE982,960 pointsBadges:
  • Connect PostgreSQL database from Powershell

    How would I be able to connect my PostgreSQL database from Powershell? I don't want to install a database driver for this. Is this possible? Thanks so much.

    ITKE982,960 pointsBadges:
  • Select PostgreSQL database active connections

    For our PostgreSQL database, is there a way that we could select all of the active connections? We're trying to drop one of the databases but it says we can't because there are active connections. Thank you.

    ITKE982,960 pointsBadges:
  • Importing CSV file into PostgreSQL table

    Is there a way for me to import CSV file into my PostgreSQL table? Is there a stored procedure to do this? Thanks so much for your help!

    ITKE982,960 pointsBadges:
  • COPY command for importing CSV file into PostgreSQL

    To import my CSV file into my PostgreSQL database, I'm trying to use the COPY command. But here's my question: Does anyone know if I have to have the CSV file in a specific location (where it's stored) or could it just be anywhere? Appreciate the help.

    ITKE982,960 pointsBadges:
  • Loading CSV file into PostgreSQL table

    I have a CSV file that's set up like this: value1|value2|value2.... How would I be able to load these into my PostgreSQL table? Appreciate the help.

    ITKE982,960 pointsBadges:
  • Allowing remote access to PostgreSQL database

    We have PostgreSQL and Windows 7 installed on my machine, followed by having Windows XP on our department's virtual machine. Would there to connect these databases? Also - would about allowing remote access so we can edit the database from each machine? Thank you.

    ITKE982,960 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • Exporting PostgreSQL database schema to XML format

    How can I go about exporting my PostgreSQL database schema to an XML format? Is there a certain code I have to use or a tool? Thank you.

    ITKE982,960 pointsBadges:
  • How to view PostgreSQL dump files

    I have to go through a ton of PostgreSQL dump files (this is for their data). Do I have to recover each file one-by-one? Or is there an easy SQL query to see them all? Thanks.

    ITKE982,960 pointsBadges:
  • Convert MySQL syntax to PostgreSQL

    Does anyone know if there's a tool that can help me convert a MySQL syntax to PostgreSQL? Would mysqldump be an option for me? Thank you.

    ITKE982,960 pointsBadges:
  • Connection limit on PostgreSQL database

    On our PostgreSQL database, my partner and I need to find out if a connection limit has been set on a per user basis. We figured out how to set the limit. Now we just need to know if such a limit was set. Thank you.

    ITKE982,960 pointsBadges:
  • Copy PostgreSQL database or schema

    Does anyone know if it's possible to create an actual copy of a PostgreSQL database? Or even the schema? We're looking to do some testing on a particular schema (which has a lot of updates) and we need to copy it because we want to compare it to the original.

    ITKE982,960 pointsBadges:
  • PostgreSQL to SQL Server database migration

    Our department has a PostgreSQL database that we need to move over to SQL Server. That includes both the schema and all the data. It's becoming a very slow process manually and we need something automatically. What should we do here? We're currently moving over the tables one-by-one.

    ITKE982,960 pointsBadges:
  • What queries are running on my PostgreSQL database?

    I'm running a PostgreSQL database and one of my applications runs queries on it. Is there a way I can see which queries are running on it? The computer I'm running it on is a Linux.

    ITKE982,960 pointsBadges:
  • PostgreSQL to MySQL data migration

    I recently changed my database from PostgreSQL to MySQL. But how can I do a data migration from one to the other? Is there a certain command to migrate the database data?

    ITKE982,960 pointsBadges:
  • PostgreSQL error when creating extension: No such file or directory

    When I'm trying to create my extension in PostgreSQL, I keep getting this error message: Could not open extension control file. No such file or directory. How can I fix that? Thanks.

    ITKE982,960 pointsBadges:
  • What is PostgreSQL

    What does PostgreSQL stand for?

    Ulrichetile5 pointsBadges:
  • What’s the best method for PostgreSQL incremental backup?

    We've been using pg_dump piped to gzip to split for PostgreSQL backups. But here's the problem: All of the output files are always changed (so basically the checksum-backup copies all of the data). Is there any other way to perform an incremental backup of a PostgreSQL database?

    ITKE982,960 pointsBadges:
  • Web project setup

    I am new the Linux servers but will be using CentOS servers. I have a web application that was created in Java using a NoSQL database. This application will give users the ability to create there own drag and drop web sites. Very similar to , Web.com, wixs.com, suarespace.com and weekly.com. We...

    sstepky60 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following