Generating a UUID in Postgres for Insert statement?

- 
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
select uuid_generate_v4() as GUID
SELECT * FROM pg_extension;

Comments

Post a Comment

Popular posts from this blog

C# DataTable to List Convert

-
public static List DataTableToList (this DataTable table) where T : class, new() { try { List list = new List (); foreach (var row in table.AsEnumerable()) { T obj = new T(); foreach (var prop in obj.GetType().GetProperties()) { try { PropertyInfo propertyInfo = obj.GetType().GetProperty(prop.Name); propertyInfo.SetValue(obj, Convert.ChangeType(row[prop.Name], propertyInfo.PropertyType), null); } catch { continue; } } list.Add(obj); } return list; } catch { return null; } } Re...
Read more

EncryptDecrypt Web config c#

-
  public static void WebEncryptDecrypt()         {             Configuration config = ConfigurationManager.OpenExeConfiguration(Application.ExecutablePath);             ConfigurationSection configSection = config.GetSection("appSettings");             ConnectionStringsSection ConSection = config.GetSection("connectionStrings") as ConnectionStringsSection;             if (configSection.SectionInformation.IsProtected)             {                 configSection.SectionInformation.UnprotectSection();                 ConSection.SectionInformation.UnprotectSection();                 config.Save();                           ...
Read more